I would use the following formula:

=(Actual-Budget)/ABS(Budget)

Regards,
Fred.

"Cristin" (donotspam) wrote in message
...
Hello,

I'm trying to calculate the % of YTD Actual # compared to the Annual
budget
#. In some cases it's easy:

YTD Actual = $10,000, Annual budget = $20,000, so 10000/20000 = 0.5
(formatted to a percentage = 50%)

However, in cases where we budgeted a loss, but have actually seen a
profit,
i'm stumped:

YTD Actual = $12,000, Annual budget = <$9,000: WHAT IS THE FORMULA FOR
THIS?

Any help is much appreciated.
--
Cristin