Prev: How do I convert an Excel file to a CSV file?
Next: why is autofilter not available (in light grey on drop down)
From: mgr on 8 Mar 2010 18:31
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
From: Fred Smith on 8 Mar 2010 18:56
The formula for percent change is:

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

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

Regards,
Fred

"mgr" <mgr(a)discussions.microsoft.com> wrote in message
news:64290F15-F746-4AAA-8F1E-BF2D9FC6786F(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: How do I convert an Excel file to a CSV file?
Next: why is autofilter not available (in light grey on drop down)