Thanks:  0
Likes:  0

# Thread: Formula for increase %

1. 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. KC, I don't understand the question, so others may not either. Can you reiterate?

Give us an exact example using cell references, etc.

3. Hi,

=(Ending Value - Beginning Value) / Beginning Value

then subtract 1

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

should work.

Bye,
Jay

4. Thanks Jay, that did it.

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

## User Tag List

#### Posting Permissions

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