Results 1 to 7 of 7

Thread: Geometric Progression - How to key into MS Excel?

  1. #1
    Deregistered
    Join Date
    Dec 2002
    Location
    Singapore
    Posts
    6,601

    Default Geometric Progression - How to key into MS Excel?

    Hi Guys,

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

  2. #2

    Default Re: Geometric Progression - How to key into MS Excel?

    Quote Originally Posted by sehsuan View Post
    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:
    1. Enter 1 into A1
    2. Enter: A1*SQRT(2) into A2
    3. 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...

  3. #3
    Deregistered
    Join Date
    Dec 2002
    Location
    Singapore
    Posts
    6,601

    Default Re: Geometric Progression - How to key into MS Excel?

    Hmm. I'm looking for a one-cell solution. Thanks for the reply thus far.

  4. #4
    Senior Member
    Join Date
    Jan 2002
    Location
    Northwest
    Posts
    5,011

    Default Re: Geometric Progression - How to key into MS Excel?

    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.

  5. #5
    Moderator Francis247's Avatar
    Join Date
    Jul 2005
    Location
    Hougang, Punggol
    Posts
    6,627

    Default Re: Geometric Progression - How to key into MS Excel?

    Quote Originally Posted by roygoh View Post
    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?
    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…

  6. #6
    Deregistered
    Join Date
    Dec 2002
    Location
    Singapore
    Posts
    6,601

    Default Re: Geometric Progression - How to key into MS Excel?

    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.

  7. #7

    Default Re: Geometric Progression - How to key into MS Excel?

    Quote Originally Posted by sehsuan View Post
    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!
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •