| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
2003= negative number&2004= negative number How Do I Calculate gro
How do you calculate the percentage of Improvement when the start value and
the new value are both negative? For example if in 2003 we had -$15,000 and in 2004 we had -$8,000 how can I calculate the percentage of improvement? What formula do I use? Because the formul |
|
#2
|
|||
|
|||
|
One way:
A1: -15000 A2: -8000 A3: =A2/A1-1 == -47% (formatted as a percentage) IOW, you reduced your deficit by 47%. In article , "Jason" wrote: How do you calculate the percentage of Improvement when the start value and the new value are both negative? For example if in 2003 we had -$15,000 and in 2004 we had -$8,000 how can I calculate the percentage of improvement? What formula do I use? Because the formul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make the cell or font color red if the number is negative? | Excel Worksheet Functions | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| calculate month from week number | Excel Worksheet Functions | |||
| How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions | |||
Linear Mode
