Formula for increase %

[KC]

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 ]

[Anne Troy]

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

Give us an exact example using cell references, etc.

[Jay Petrulis]

Hi,

=(Ending Value - Beginning Value) / Beginning Value

then subtract 1

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

should work.

Bye,
Jay

[KC]

Thanks Jay, that did it.

[Yogi Anand]

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

[Jay Petrulis]

On 2002-05-01 14:42, Yogi Anand wrote:

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 ]