If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How would I do this sum in Excel please?
am new to excel (and maths to some extent!) so how do I put the following
calculation into the formula bar please. 42,450 x (1+0.004167) to the power of 120 |
#2
|
|||
|
|||
How would I do this sum in Excel please?
I would use:
=42450*(1.004167^120) Denise Green wrote: am new to excel (and maths to some extent!) so how do I put the following calculation into the formula bar please. 42,450 x (1+0.004167) to the power of 120 -- Dave Peterson |
#3
|
|||
|
|||
How would I do this sum in Excel please?
|
#4
|
|||
|
|||
How would I do this sum in Excel please?
Presuming you want to do the additon, then the multiplication, then exponent,
it would be =(42450*(1.004167))^120 However, 1.79769313486231^308 is the largets number allowed in a cell, so this would exceed the limit. "Denise Green" wrote: am new to excel (and maths to some extent!) so how do I put the following calculation into the formula bar please. 42,450 x (1+0.004167) to the power of 120 |
#5
|
|||
|
|||
How would I do this sum in Excel please?
"Sean Timmons" wrote:
Presuming you want to do the additon, then the multiplication, then exponent, it would be =(42450*(1.004167))^120 You forgot some parentheses, to wit: =(((42450)*(1.004167))^(120)) :-) :-) :-) Good point about the ambiguity of the English description. I decided not to mention it myself because I thought the form of her description made her application clear. But you know what they say about ass-u-me ;-). ----- original message ----- "Sean Timmons" wrote in message ... Presuming you want to do the additon, then the multiplication, then exponent, it would be =(42450*(1.004167))^120 However, 1.79769313486231^308 is the largets number allowed in a cell, so this would exceed the limit. "Denise Green" wrote: am new to excel (and maths to some extent!) so how do I put the following calculation into the formula bar please. 42,450 x (1+0.004167) to the power of 120 |
#6
|
|||
|
|||
How would I do this sum in Excel please?
PS....
I wrote: But if 0.004167 represents 50%/120 Actually, I suspect it represents 5%/12. in general it would be more accurate and less error-prone to write: =42450*(1+5%/12)^120 or =FV(5%/12, 10*12, 0, -42450) ----- original message ----- "Joe User" joeu2004 wrote in message ... "Denise Green" Denise wrote: am new to excel (and maths to some extent!) so how do I put the following calculation into the formula bar please. 42,450 x (1+0.004167) to the power of 120 You could write any of the following: =42450*(1+0.004167)^120 =42450*1.004167^120 =42450*(1.004167^120) But if 0.004167 represents 50%/120, in general it would be more accurate and less error-prone to write: =42450*(1+50%/120)^120 And if you are doing future-value calculations, it might more clear and more generally applicable to write: =FV(50%/120, 120, 0, -42450) |
#7
|
|||
|
|||
How would I do this sum in Excel please?
Yeah, I've ass-u-me'd more than my share of times on here. :-)
"Joe User" wrote: "Sean Timmons" wrote: Presuming you want to do the additon, then the multiplication, then exponent, it would be =(42450*(1.004167))^120 You forgot some parentheses, to wit: =(((42450)*(1.004167))^(120)) :-) :-) :-) Good point about the ambiguity of the English description. I decided not to mention it myself because I thought the form of her description made her application clear. But you know what they say about ass-u-me ;-). ----- original message ----- "Sean Timmons" wrote in message ... Presuming you want to do the additon, then the multiplication, then exponent, it would be =(42450*(1.004167))^120 However, 1.79769313486231^308 is the largets number allowed in a cell, so this would exceed the limit. "Denise Green" wrote: am new to excel (and maths to some extent!) so how do I put the following calculation into the formula bar please. 42,450 x (1+0.004167) to the power of 120 . |
#8
|
|||
|
|||
How would I do this sum in Excel please?
Good point about the ambiguity
Sometimes using Power can help. =42450*POWER(1+5%/12, 120) = = = = = = = On 11/13/09 4:12 PM, Sean Timmons wrote: Yeah, I've ass-u-me'd more than my share of times on here. :-) "Joe User" wrote: "Sean wrote: Presuming you want to do the additon, then the multiplication, then exponent, it would be =(42450*(1.004167))^120 You forgot some parentheses, to wit: =(((42450)*(1.004167))^(120)) :-) :-) :-) Good point about the ambiguity of the English description. I decided not to mention it myself because I thought the form of her description made her application clear. But you know what they say about ass-u-me ;-). ----- original message ----- "Sean wrote in message ... Presuming you want to do the additon, then the multiplication, then exponent, it would be =(42450*(1.004167))^120 However, 1.79769313486231^308 is the largets number allowed in a cell, so this would exceed the limit. "Denise Green" wrote: am new to excel (and maths to some extent!) so how do I put the following calculation into the formula bar please. 42,450 x (1+0.004167) to the power of 120 . |
Thread Tools | |
Display Modes | |
|
|