Using a collegues formula: =IF(D6=0,0,F6/D6)

I am trying to get the % change between columns D and E. Problem is D and E
contain Zero at times. If D has a negative number or Zero, the % change is
not always accurate.

Tried the following, but if D is a zero then the result will not always be
correct.

=IF(D6<=0,0+F6,E6/D6-1)

Especially if D1=0, E1=2.

Where does F6 come from in your formula?

Pete

On Jan 17, 4:35*pm, asg2307 wrote:
Using a collegues formula: *=IF(D6=0,0,F6/D6)

I am trying to get the % change between columns D and E. *Problem is D and E
contain Zero at times. *If D has a negative number or Zero, the % change is
not always accurate.

Tried the following, but if D is a zero then the result will not always be
correct. *

=IF(D6<=0,0+F6,E6/D6-1)

Especially if D1=0, E1=2.

How do you wish to define the percentage change from D to E if D is zero?
Under normal terminology the percentage change would be infinite, but what
do you want to call it?
I would tend to do something like =IF(D6=0,"infinite change",E6/D6-1) , but
the choice is yours. You may also need to think about how you want to
define the percentage change if you are starting from a negative value.
--
David Biddulph

"asg2307" wrote in message
...
Using a collegues formula: =IF(D6=0,0,F6/D6)

I am trying to get the % change between columns D and E. Problem is D and
E
contain Zero at times. If D has a negative number or Zero, the % change
is
not always accurate.

Tried the following, but if D is a zero then the result will not always be
correct.

=IF(D6<=0,0+F6,E6/D6-1)

Especially if D1=0, E1=2.

=e1-d1 which is suppose to give net change, This is a comparison between
2007 and 2008. Numbers are very small.

"Pete_UK" wrote:

Where does F6 come from in your formula?

Pete

On Jan 17, 4:35 pm, asg2307 wrote:
Using a collegues formula: =IF(D6=0,0,F6/D6)

I am trying to get the % change between columns D and E. Problem is D and E
contain Zero at times. If D has a negative number or Zero, the % change is
not always accurate.

Tried the following, but if D is a zero then the result will not always be
correct.

=IF(D6<=0,0+F6,E6/D6-1)

Especially if D1=0, E1=2.

The ultimate answer from this formula will be in cell G and in percentages.

"David Biddulph" wrote:

How do you wish to define the percentage change from D to E if D is zero?
Under normal terminology the percentage change would be infinite, but what
do you want to call it?
I would tend to do something like =IF(D6=0,"infinite change",E6/D6-1) , but
the choice is yours. You may also need to think about how you want to
define the percentage change if you are starting from a negative value.
--
David Biddulph

"asg2307" wrote in message
...
Using a collegues formula: =IF(D6=0,0,F6/D6)

I am trying to get the % change between columns D and E. Problem is D and
E
contain Zero at times. If D has a negative number or Zero, the % change
is
not always accurate.

Tried the following, but if D is a zero then the result will not always be
correct.

=IF(D6<=0,0+F6,E6/D6-1)

Especially if D1=0, E1=2.