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 |
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 |
All times are GMT +1. The time now is 12:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com