Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percent increase | Excel Worksheet Functions | |||
Percent increase in excel | New Users to Excel | |||
Percent increase in excel | New Users to Excel | |||
Percent Increase | Excel Discussion (Misc queries) | |||
calculate percent increase | Excel Discussion (Misc queries) |