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

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

How would I do this sum in Excel please?
 

"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)

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

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

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)

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

.

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

.