Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What formula do I use to find a percentage change?
I'm new to using Excel and I just need to find a formula to use that will
calculate a percentage change from one cell to another. |
#2
|
|||
|
|||
I think you can use this, Lizzy: =(A2-A1)/A1
************ Anne Troy www.OfficeArticles.com "buzy lizzy" <buzy wrote in message ... I'm new to using Excel and I just need to find a formula to use that will calculate a percentage change from one cell to another. |
#3
|
|||
|
|||
One way:
=(A2-A1)/A1 formatted as a percentage, which can be simplified to =A2/A1 - 1 also formatted as a percentage. In article , "buzy lizzy" <buzy wrote: I'm new to using Excel and I just need to find a formula to use that will calculate a percentage change from one cell to another. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
What formula do I use to find a percentage change?
Hi Litty
I am rally trying but no luck. what is the percentage? E6 F6 =% difference of those two below? 1.06 0.98 =SUM(E6:F6) "buzy lizzy" wrote: I'm new to using Excel and I just need to find a formula to use that will calculate a percentage change from one cell to another. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
What formula do I use to find a percentage change?
=ABS(1-(E6/F6))
Cliff Edwards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping one part of a formula same, but change other cell ref? | Excel Discussion (Misc queries) | |||
How to change a formula in one cell and have these changes appear | Excel Worksheet Functions | |||
percentage formula | Excel Discussion (Misc queries) | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
Cannot change a formula | Excel Discussion (Misc queries) |