Hi All,
I find that in an Excel installation 2002 the function Weeknum is not present. Is it possible? How can I include it? Or where is the problem? Problem in settings?
Any help will be well appreciated.
Thanks in advance for your kind help.
Regards,
Giovanni
is there an easy way to do this??? I am trying to convert the RATE() function to a normal math formula, so I can calculate it within another program... Here is the example I am trying to convert to normal math B1 is the function.
Microsoft Excel - Book1
___Running: xl2002 XP : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
B1
B6
=
A
B
C
D
1
Interest Rate
7.00%
2
3
Total Interest
279,017.80
4
# Years in Loan
30
5
# Payments / Year
12
6
Total Payments
360
7
Beginning Principal
200,000.00
8
Ending Balance
0
Sheet2
I often use excel as a fancy calculator. But often I forget to start the
calculator with the = sign. So if I want to add 44 + 66, I forget to
type in an = sign first, an it gives me an error message. Is there a
setting to turn that off, so I can type in 44 + 66 and it gives me an
answer.
I often use excel as a fancy calculator. But often I forget to start the
calculator with the = sign. So if I want to add 44 + 66, I forget to
type in an = sign first, an it gives me an error message. Is there a
setting to turn that off, so I can type in 44 + 66 and it gives me an
answer.
Hi Everyone - can any of you help me with this question in my assignment?
I'd be very grateful for any assistance!
. Write a function named PValue(cfs, per, r) that returns the present value of a set of cash flows contained in the range cfs (cfs can be either a row or a column.). The range per contains the periods in which each cash flow occurs (e.g. the first cash flow in cfs occurs in period 2, the second cash flow is in period 5). The discount rate is r per period. Do not use any Excel functions within PValue().
Hi i want to create formula something like this
=((B5*$AJ$5)+(B6*$AJ$6)+(B7*$AJ$7)+(B8*$AJ$8))
Itz working fine without any problem.
Now the my query is i want to continue to formula till 98 column some thing like this
=((B5*$AJ$5)+(B6*$AJ$6)+(B7*$AJ$7)+(B8*$AJ$8)...........+(B97*$AJ$97)+(B98*$AJ$98))
So can any one please let me know who do i create that formula. du i need to manually enter upto 98 columns orelse is there any other function which can solve my problem
Thanks in advance
The problem with my Excel is that I noticed a sum function that gave a clearly incorrect answer. The sum function (red) adds the yellow and blue values, which anyone with 3rd grade math knows is 257.7. However, the result of the function is 253.3 in the red box.
The yellow and blue boxes are summing many rows of numbers themseves, perhaps that has something to do with it?
Help! It's very difficult to work with Excel when I can't trust the results of the functions I run.
http://i91.photobucket.com/albums/k2...sc/problem.jpg
Can any one help me with a problem? What I have is 5 cell A5 to E5 in a row
with 500 in each one, then I have column with 7 cell B7 to B13 with different
numbers in it, then have two cell D7 to D8 with drop list in each one for
cell in roll A5 to E5. Now when I put numbers in column B7 to B13 it
subtracts from one drop list of which cell I pick to take away from D7 of
500, ? is how do you get it to subtract from cell B8 when B7 gets to zero? If
I had 100 in each cell from B7 to B13 thats 700 , B7 has 500 and B8 has 500,
I dont what D7 to show -200 want it to pick up from B8. This make any sense?
How do I create a function (equation) that goes through my three points. I want my function to be some sort of root fuction where the root is less than 1.
e.g. y = x ^(1/3)
the points a
y = 0.25; x =100
y = 0.5; x = 150
y = 0.9; x = 350
I am new to this forum and I really hope someone can help.
I have a spreadsheet with a colum that has tons of fractions that look like this(22/8, 45/6, 313/9, etc.) you get the point. What I am asked to do is go through this colum and change each one to a whole number (ex. 22/8 would be changed to 23, 45/6 is changed to 46). Basically what I want to do to save so much time(and I'm not sure if this is possible) is to make a function that will find the fraction, for instance 22/8, multiply it by the bottome number (8) and then add 1. I really hope someone can help. If i'm unclear, let me know and I will try to explain better. Thanks sooo much in advance.
