Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Formula for increase %

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm at working and trying to find the formula for percentage increase, 1992-03, 16; 2001-02, 20. I've tried a couple of things but the % number has too many digits. Can you help me with the formula.

    KC

    [ This Message was edited by: KC on 2002-04-26 06:58 ]

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    KC, I don't understand the question, so others may not either. Can you reiterate?

    Give us an exact example using cell references, etc.
    ~Anne Troy

  3. #3
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    =(Ending Value - Beginning Value) / Beginning Value

    then subtract 1

    =((B1-A1)/A1)-1

    should work.

    Bye,
    Jay

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Jay, that did it.

  5. #5
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-26 07:04, Jay Petrulis wrote:
    Hi,

    =(Ending Value - Beginning Value) / Beginning Value

    then subtract 1

    =((B1-A1)/A1)-1

    should work.

    Bye,
    Jay
    Hi Jay:
    If I understood correctly, the OP is trying to find the % increse from figures of 16 and 20, so if A1=16, B1=20 -- then % increase would be:

    =(B1-A1)/A1 formatted as % will give 25%

    If this is the case then your formula
    =((B1-A1)/A1)-1 should be =(B1-A1)/A1

    It is simplistic but I just wondered whether I had understood it correctly.

    Regards!
    Yogi Anand

  6. #6
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-01 14:42, Yogi Anand wrote:
    On 2002-04-26 07:04, Jay Petrulis wrote:
    Hi,

    =(Ending Value - Beginning Value) / Beginning Value

    then subtract 1

    =((B1-A1)/A1)-1

    should work.

    Bye,
    Jay
    Hi Jay:
    If I understood correctly, the OP is trying to find the % increse from figures of 16 and 20, so if A1=16, B1=20 -- then % increase would be:

    =(B1-A1)/A1 formatted as % will give 25%

    If this is the case then your formula
    =((B1-A1)/A1)-1 should be =(B1-A1)/A1

    It is simplistic but I just wondered whether I had understood it correctly.

    Regards!
    Yogi Anand
    Hi Yogi,

    Oops! Yes, a careless error. I am usually taking these numbers into a GEOMEAN function, or something like that, so I need to add one to the result, raise it to the right power, and then subtract one. Obviously not the case here.

    Nice catch. Thanks for keeping me on my toes.

    B1/A1 - 1
    would also work

    Bye,
    Jay

    [ This Message was edited by: Jay Petrulis on 2002-05-01 15:27 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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