Remember Me?

#1
August 25th 05, 05:03 PM
 mdalby Posts: n/a
Percent Variance Formula

What should be the correct formula for % Variance?

(New - Old) / Old??

If I have a forecast and an actual would the formula be:

(Actual - Forecast) / Forecast

Thanks,

MD

--
mdalby
------------------------------------------------------------------------
mdalby's Profile: http://www.excelforum.com/member.php...fo&userid=7055

#2
August 25th 05, 05:07 PM
 Excel_Geek Posts: n/a

It's really relative to what you're trying to convey:

Example, if you'd like to say that the actual results varied from the
forecast by x%, you'd use =(actual - forecast)/forecast.

If you'd like to say that the forecast was off by x%, use

= (forecast - actual)/actual.

--
Excel_Geek

------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Lori Lynn Excel Discussion (Misc queries) 2 July 25th 05 08:41 PM MarthaSue Setting up and Configuration of Excel 18 April 28th 05 12:31 AM Werner Rohrmoser Excel Worksheet Functions 2 April 20th 05 04:56 PM Ken Excel Worksheet Functions 1 February 7th 05 09:26 AM Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM

All times are GMT +1. The time now is 10:45 PM.