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" <ChristyB@discussions.microsoft.com> wrote in message
news:4216C899-6543-484A-91FD-0DB372B4DDD1@microsoft.com...
>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?