View Single Post
  #1   Report Post  
mdalby
 
Posts: n/a
Default 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
View this thread: http://www.excelforum.com/showthread...hreadid=399107