#DIV/0! Error

[Patrick]

Can anyone tell me why this insists on bringing up the #DIV/0! Error
=IF((E6-F6)/E6="0","",(E6-F6)/E6)

 

[g_erhard]

On 2002-01-14 16:20, Patrick wrote:
Can anyone tell me why this insists on bringing up the #DIV/0! Error
=IF((E6-F6)/E6="0","",(E6-F6)/E6)

Egads, I'm surprised no one nailed this down already.

Patrick, you probably already solved this, but in case you did not, here goes.

Look at your IF "condition":
(E6-F6)/E6="0"

The only times this condition will be TRUE is when E6 and F6 are EQUAL. Then your equation collapses to (0/E6); any time you devide zero by something you get zero.

A better test for your purposes is:

E6=0

because what you REALLY want to avoid with this IF equation is having to divide by zero, which is undefined and thus causes computers to have hissy fits.

So, your IF formula should read:
=IF(E6=0,"",(E6-F6)/E6)

which allows the results to be computed and displayed, and instead of getting DIV/0 errors, you get blanks whenever E6 happens to be 0.

 

[James]

Maybe this:

=If(I7,G7/I7-1,0)

change cell refs to suit

James

 

[Aladin Akyurek]

I'm surprised no one nailed this down already.

Do a Search on this poster's name, you'll understand.

Aladin

 

[g_erhard]

let me guess, he's the type that posts repeatedly until someone gets on it.

whereas I'm the one that skips randomly through the archives in search of easy questions...

 

[chouston]

On 2002-01-14 16:20, Patrick wrote:
Can anyone tell me why this insists on bringing up the #DIV/0! Error
=IF((E6-F6)/E6="0","",(E6-F6)/E6)

perhaps this would help:

=IF(E6<>0,IF((E6-F6)/E6 = 0,"",(E6-F6)/E6),"")

 

[NateO]

Using one of Aladin's tricks (This was a good one Al):

=if(e6,(e6-f6)/e6,o)

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue">O</font></font></font>

This message was edited by NateO on 2002-05-06 18:02