Thanks for quick reply.

Forecast is 15, Actual is 20.
=forecast/actual gives me 75% indeed.

However, if forecast=418 and actual=320, then 418/320=131% when cell is
formatted as percentage. ?

In this instance where actual is less than forecast should I switch the
formula to =actual/forecast? Therefore 320/418=77%.

As I want to see how accurate the customer was in it's forecast, I think 77%
is a better figure (if it is correct). The customer then, was only 77%
accurate, irrespective of whether actual is greater than forecast or vice
versa.


"vezerid" wrote:

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