Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate a negative %? 150,000/0 = (xxx%)
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate a negative %? 150,000/0 = (xxx%)
"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. 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 ----- "Spanky" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate a negative %? 150,000/0 = (xxx%)
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate hours without negative | Excel Worksheet Functions | |||
How do you calculate a negative percentage | Excel Worksheet Functions | |||
Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
calculate the p-value for a negative t-value | Excel Worksheet Functions | |||
2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions |