- Thread starter sehsuan
- Start date

- Status
- Not open for further replies.

Hi Guys,

Seeking Excel Wizards here. How'd you key in the formula for a GP in Excel? Thanks!

Seeking Excel Wizards here. How'd you key in the formula for a GP in Excel? Thanks!

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

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?

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?

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

To calculate Sum to first n terms of a G. P.,

(a*(1-r^n))/(1-r) OR (a*(r^n-1))/(r-1)

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!

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!

36000*(1+2%)^17 and the answer is 50409.69

- Status
- Not open for further replies.