RE: Percentage Accuracy

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 01:39:02 -0800

Hi
try
=MAX(0,your_formula)

"Eagle" wrote:

> 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
>
>
>