A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How would I do this sum in Excel please?



 
 
Thread Tools Display Modes
  #1  
Old November 13th, 2009, 07:34 PM posted to microsoft.public.excel.misc
Denise Green
external usenet poster
 
Posts: 1
Default 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  
Old November 13th, 2009, 07:37 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default 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
  #4  
Old November 13th, 2009, 08:00 PM posted to microsoft.public.excel.misc
Sean Timmons
external usenet poster
 
Posts: 1,722
Default 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  
Old November 13th, 2009, 08:15 PM posted to microsoft.public.excel.misc
Joe User[_2_]
external usenet poster
 
Posts: 757
Default 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  
Old November 13th, 2009, 08:17 PM posted to microsoft.public.excel.misc
Joe User[_2_]
external usenet poster
 
Posts: 757
Default 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  
Old November 13th, 2009, 10:12 PM posted to microsoft.public.excel.misc
Sean Timmons
external usenet poster
 
Posts: 1,722
Default 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  
Old November 14th, 2009, 04:55 AM posted to microsoft.public.excel.misc
Dana DeLouis[_3_]
external usenet poster
 
Posts: 184
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:18 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.