Hi Christy

Assuming your real data is in A1 and your budget in B1 then enter in C1
=IF(B1<1,"Not Applicable",A1/B1)
Format Cell C1 as Percentage, copy down column C as far as required
If the Budget is 0, you cannot have a percentage increase, as this would
be infinity (and Excel would throw up a #DIV/0 error), hence the If test
at the beginning of the formula.

--
Regards

Roger Govier


"ChristyB" wrote in message
...
I am looking to compare actuals to budgeted amounts.
The actuals are real $. The amount budgeted was $0.00. I need the
percentage over. What formula can I use to get the % over budget in
Excel?