View Single Post
  #2   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

If you want to express the actual as a percentage of the forecast, the
formula is:
=actual/forecast.
So, 15 is 15/20 = 75% of forecast 20.

If you want to express the percentage as a deviation from forecast then
you need the difference:
=(actual-forecast)/forecast
So, 15 is -5/20 = -25% less than forecast.

Does this help?
Kostis Vezerides