| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MOM % change
Hello
I am trying to calculate month over month percentage change in revenue and this is for 6 months. What formula would I use? here are the values from July to Feb $31,099 $46,895 $83,447 $234,181 $324,901 $432,667 $74,268 $110,715 Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MOM % change
The formula for percent change is:
=(newvalue - oldvalue) / oldvalue Format as percent. For example, =(46895-31099)/31099 =50.8% Regards, Fred "mgr" wrote in message ... Hello I am trying to calculate month over month percentage change in revenue and this is for 6 months. What formula would I use? here are the values from July to Feb $31,099 $46,895 $83,447 $234,181 $324,901 $432,667 $74,268 $110,715 Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel graphs change when pasted into Publisher - Metafiles change? | Charts and Charting in Excel | |||
| change formula in a shared worksheet without losing change history | Excel Worksheet Functions | |||
| Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
Linear Mode
