Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to figure out a percentage
I need an equation to figure out: We budget $0 (or breakeven) and
actually make / or lose say $1000. I can't figure out how to get a percentage for this, whether it's positive or minus. Could anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to figure out a percentage
wrote in message
ups.com... I need an equation to figure out: We budget $0 (or breakeven) and actually make / or lose say $1000. I can't figure out how to get a percentage for this, whether it's positive or minus. Could anyone help? Try =(Sale Price / Cost Price) - 1 and format as percentage -- David Biddulph |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to figure out a percentage
David beat me to this response, but I will offer a minor change: where
your budget is zero, enter the figure .000000001 and format it as currency. This is effectively a zero value, but it is still a non-zero number. A zero entry will cause a #DIV/0 error. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to figure out a percentage
The reason you are having problems is that you are zero-based. There is an
easy fix. Let's say you estimate expenses (including profit) of $50,000 and income of $50,000. Your estimated net is $0.00, but you actually have income of $51,000. Your percentage should be 1000/50000 or 2% -- Gary's Student " wrote: I need an equation to figure out: We budget $0 (or breakeven) and actually make / or lose say $1000. I can't figure out how to get a percentage for this, whether it's positive or minus. Could anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMAT PERCENTAGE IN INDEX CELL? | New Users to Excel | |||
Percentage difference calc that knows the largest figure | Excel Discussion (Misc queries) | |||
Formatting percentage signs in Excel | Excel Discussion (Misc queries) | |||
percentage of production against quotation | Excel Discussion (Misc queries) | |||
percentage of sales | Excel Worksheet Functions |