MOM % change

[mgr]

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]

The formula for percent change is:

=(newvalue - oldvalue) / oldvalue
Format as percent.

For example,
=(46895-31099)/31099
=50.8%

Regards,
Fred