| 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) | |||
Linear Mode
