View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default Show forecast accuracy of customer schedules as a percentage

Dave,

First, if you examine the accuracy of the forecast, it must stay in the
denominator.
Second, why are you troubled with percentages greater than 100? A 131%
means exactly this: that the actual was 31% more than the forecast.

The second formula I gave you essentially is maybe better for your
thinking. It would return
-25% for a lower actual and +31% for a higher actual. Both are
percentages on the forecast.

Does this help?
Kostis