#DIV/0! Error

[Aladin Akyurek]

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

Try:

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

 

[Patrick]

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

 

[Aladin Akyurek]

In case you didn't see any reply...

 

[Jay Petrulis]

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

Hi,

Aladin already provide the solution, but the reason you are receiving a #DIV/0! error is because your test condition is comparing the result of a calculation with a string, not a number. So, the FALSE condition occurs and you return a result that divides by zero.

Aladin's formula is much nicer, but you can achieve the same thing you want by removing the quotes around the zero.

Bye,
Jay