Thread: MOM % change
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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