Calculating growth with negative numbers
 

I am trying to calculate growth rates with negative and positive numbers.
Using a simple (Period 2-Period 1)/Period 1 is not sufficient because the +
or - growth % is not properly reflecting if I have positive growth because I
have gone from negative Net Income to Positive Net Income. How can I change
the formula so that I can make sure that % growth is calculating properly
whether or not I have positive or negative numbers?

Thanks!

Answer: Calculating growth with negative numbers
 

Calculating Growth Rates with Negative and Positive Numbers

When dealing with negative and positive numbers, calculating growth rates can be a bit tricky. However, there is a way to modify the formula to ensure that the growth percentage is calculated properly.

Instead of using the simple formula , you can use the following formula to calculate growth rates with negative and positive numbers:

The ABS function will ensure that the denominator (Period 1) is always a positive number, which will allow the growth percentage to be calculated properly regardless of whether the numbers are negative or positive.

Here's an example to illustrate how this formula works:

1. Let's say that in Period 1, your net income was -$10,000 and in Period 2, your net income was $5,000.
2. Using the simple formula, the growth rate would be calculated as follows:
   
   
   Code:

   ---

   ($5,000 - (-$10,000)) / (-$10,000) = 1.5 or 150%

   ---

   This growth rate doesn't accurately reflect the fact that your net income has gone from negative to positive.
3. Using the modified formula, the growth rate would be calculated as follows:
   
   
   Code:

   ---

   (($5,000 - (-$10,000)) / ABS(-$10,000)) * 100 = 150%

   ---

   This growth rate accurately reflects the fact that your net income has increased by 150%.

Depends on what you call "proper". I assume you want positive percentages
for growth and negative percentages for decreasing values. And you probably
require 300% growth displayed if you go from -100 to 200.
I wouldn't dare to call that proper, but if it is what you require you could
use a formula like

=IF(B1A1,ABS((B1-A1)/A1),-ABS((B1-A1)/A1))

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Tsipi4me" wrote in message
...
I am trying to calculate growth rates with negative and positive numbers.
Using a simple (Period 2-Period 1)/Period 1 is not sufficient because the
+
or - growth % is not properly reflecting if I have positive growth because
I
have gone from negative Net Income to Positive Net Income. How can I
change
the formula so that I can make sure that % growth is calculating properly
whether or not I have positive or negative numbers?

Thanks!

Thanks! This is exactly what I needed

"Niek Otten" wrote:

Depends on what you call "proper". I assume you want positive percentages
for growth and negative percentages for decreasing values. And you probably
require 300% growth displayed if you go from -100 to 200.
I wouldn't dare to call that proper, but if it is what you require you could
use a formula like

=IF(B1A1,ABS((B1-A1)/A1),-ABS((B1-A1)/A1))

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Tsipi4me" wrote in message
...
I am trying to calculate growth rates with negative and positive numbers.
Using a simple (Period 2-Period 1)/Period 1 is not sufficient because the
+
or - growth % is not properly reflecting if I have positive growth because
I
have gone from negative Net Income to Positive Net Income. How can I
change
the formula so that I can make sure that % growth is calculating properly
whether or not I have positive or negative numbers?

Thanks!