| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating a % attainment when base number is negative
I want to write a formula that calculates the percent attainment of a goal
i.e. profit goal. If i have a goal of $-100 and actually attain $100 (positive) profit. What is the formula to write such that the resulting % does not contain a negative? Additionally, would like the same formula to take into account if goal is $-100 and actually attain $-60, the % attainment should be positive. any advise? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating and posting when a qty will go negative. | Excel Worksheet Functions | |||
| possible to calculate % attainment using one formula? | Excel Discussion (Misc queries) | |||
| How do I set the number format to Base 12? | Excel Discussion (Misc queries) | |||
| Calculating negative time. | Excel Discussion (Misc queries) | |||
| 2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
Threaded Mode
