2003= negative number&2004= negative number How Do I Calculate gro

J

Jason

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
 
J

JE McGimpsey

One way:

A1: -15000
A2: -8000
A3: =A2/A1-1 ==> -47% (formatted as a percentage)

IOW, you reduced your deficit by 47%.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create the formula for this calculation? 1
Rounding Negative Numbers to Zero 4
Excluding Negative Numbers 9
How do you calculate a negative percentage 2
How do I limit formula results to positive only? 4
difference in numbers displayed as a +/- percentage 3
How to average the last 10 numbers in a row? 9
How do I get a index% of two numbers when they are negative or pos 1

Top