How do I calculate a negative %? 150,000/0 = (xxx%)

[Spanky]

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!

 

[JoeU2004]

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.

Can't help you there, since you did not post your formula. Could be simply
a formatting problem.

I need a formula
that works regardless of whether I'm overbudget or underbudget

If A1 is the budgeted amount and B1 is the actual amount, the following
calculates % over and minus % under the budgeted amount.

=B1/A1 - 1

formatted as Percentage with 2 decimal places or whatever you wish to see.

If the budgeted amount could zero, then perhaps:

=if(A1=0, 100%, B1/A1 - 1)


----- original message -----

 

[FSt1]

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