Remember Me?

#1
December 29th 04, 04:45 AM
 Tsipi4me Posts: n/a
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!

#2
December 29th 04, 02:18 PM
 Niek Otten Posts: n/a

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!

#3
December 29th 04, 05:17 PM
 Tsipi4me Posts: n/a

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!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Bruce Excel Discussion (Misc queries) 5 December 6th 05 04:26 PM Dede Excel Discussion (Misc queries) 3 January 14th 05 06:23 PM Jerri Excel Discussion (Misc queries) 4 January 8th 05 05:05 PM Glenda Excel Discussion (Misc queries) 3 November 26th 04 02:06 PM Dawn Boot-Bunston Excel Worksheet Functions 5 November 24th 04 09:57 PM

All times are GMT +1. The time now is 03:49 AM.