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
View this thread:
http://www.excelforum.com/showthread...hreadid=399107