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
.
|