Percent increase
 

I'm trying to find a percentage increase formula from one cell to another. I
know, now, that a percentage change formula is =(a1-b1)/b1, but what about an
increase instead of change? Please help me with this simple equation

Please explain the difference between a % increase and a % change.
************
Anne Troy
www.OfficeArticles.com

"buzy lizzy" wrote in message
...
I'm trying to find a percentage increase formula from one cell to another.
I
know, now, that a percentage change formula is =(a1-b1)/b1, but what about
an
increase instead of change? Please help me with this simple equation

If your "New" value is in A2 and your "Old" value is in A1, then the
percentage increase from A1 to A2 is:

=A2/A1-1

--
Regards,
Dave
<!--


"buzy lizzy" wrote:

I'm trying to find a percentage increase formula from one cell to another. I
know, now, that a percentage change formula is =(a1-b1)/b1, but what about an
increase instead of change? Please help me with this simple equation