Percentage Accuracy

[Eagle]

Hi, I have a problem developing a formula that reports forecast vs actual
accuracy.

All values returned must be between 0-100%, so if any negative results are
returned the forecast accuracy must default to 0%.eg:

Forecast = 180
Actual = -153
% Accuracy = 0% (not -.85%)

If someone forecasts a negative value for the month and achieves that value
(or close to it) the formula must treat it as an absolute value and return
between 0-100%.

Forecast -92
Actual -90
% Accuracy = 98%

Any ideas?

Thanks

 

[Guest]

Hi
try
=MAX(0,your_formula)