ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   MOM % change (https://www.excelbanter.com/excel-discussion-misc-queries/258342-mom-%25-change.html)

mgr

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

Fred Smith[_4_]

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