#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)

 

[shalini]

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

most probably E6 has 0 or no value. Try checking the value of E6 instead of checking the whole formula in the if condition.

 

[Aladin Akyurek]

In addition to what Shalini noted:

Any number including 0 divided by 0 is undefined and Excel renders this as #DIV/0!

An empty cell in math expressions interpreted by Excel as 0.

Rewrite your formula as:

=IF(E6,(E6-F6)/E6,"")

 

[Chris Davison]

your first arguement that says if it's equal to "0" is telling it to recognise a textual value of "0"

even if your (E6-f6/e6) is zero, it's not recognising it as text, and thusly defaulting to your 2nd arguement, which results in a division by zero....

drop the "quotes" or go with Aladin's more compact solution

 

[Aladin Akyurek]

On 2002-04-26 12:26, Chris Davison wrote:
your first arguement that says if it's equal to "0" is telling it to recognise a textual value of "0"

even if your (E6-f6/e6) is zero, it's not recognising it as text, and thusly defaulting to your 2nd arguement, which results in a division by zero....

drop the "quotes" or go with Aladin's more compact solution

Guess what: Dropping the quotes won't help when E6=0 or empty .

 

[Chris Davison]

Guess what : I posted without testing it first.

Naughty Chris