Hi Guys,
Seeking Excel Wizards here. How'd you key in the formula for a GP in Excel? Thanks!
Hi Guys,
Seeking Excel Wizards here. How'd you key in the formula for a GP in Excel? Thanks!
Erm, not exactly sure what you want, see if the following steps are sort of what you're looking for:
- Enter 1 into A1
- Enter: A1*SQRT(2) into A2
- Select A2 to A10, then click Edit / Fill / Down
or
Hover mouse over the bottom-left corner of A2 cell, where the corner dot is thicker; the
cursor turns to +, then click and drag it to fill down...
Hmm. I'm looking for a one-cell solution. Thanks for the reply thus far.
If you can describe what you are trying to achieve in more detail then you can get more specific answers.
Are you trying to calculate a specific term in a GP series, given the first term and the ratio? Or are you trying to calculate the sum of a finite number of terms? Or are you trying to geerate a GP in a series of cells?
As complexity rises, precise statements lose meaning and meaningful statements lose precision.
Agree with Roy.
If you are trying to generate a GP in the series of cells, you can use what ah.zeep suggested.
To Calculate specific term nth term in the GP series,
a*(r^(n-1)) where you let the first term be a and common ratio be r
To calculate Sum to first n terms of a G. P.,
(a*(1-r^n))/(1-r) OR (a*(r^n-1))/(r-1)
莫问前程有愧,只求今生无悔. Time pasts, Places changed, Beauty faded, what is left are Photos of Memories…
something seems to be wrong the way i'm doing it.
let's say, i'm calculating $36000/pa, for 17 years, at 2%. i want to get the sum, but seem to be getting the nth term instead, because i'm getting 39130.xxx as the answer... argh I'm looking for the sum of it.. any help from here?
thanks!
Last edited by sehsuan; 13th January 2007 at 02:49 PM.
I have no idea what is GP but based on your explanation above, are you trying to see what will be the final amount of your investment ($36k) at a constant growth rate of 2% pa for 17 years? If it is so, the 1 cell formula will be:
36000*(1+2%)^17 and the answer is 50409.69
Last edited by kiat; 13th January 2007 at 03:52 PM. Reason: add on
Bookmarks