hi
not sure but different people look at it different ways so.....
actual/budgeted-1. format at percent.
100k/150k-1 = -33.34% under budget
50k/150k-1 = -66.67% under budget
0 / 150k-1= -100.00% under budget
200k/150k-1 = 33.34% over budget

regards
FSt1

"Spanky" wrote:

I have a budgeted # (i.e. $150,000), An actual # (i.e. 0-zero). I'm trying
to calculate the % I'm underbudget. But, I only get zero. I need a formula
that works regardless of whether I'm overbudget or underbudget to go in a
column that will calculate Actuals vs. Budgeted numbers. Thanks!