IF statement checking #DIV/0!

**themachine** · 07-22-2010, 08:42 AM

Trying to do:

IF(Cell=#DIV/0!, "Foo", "Bar")

doesn't seem to work

**arthurbr** · 07-22-2010, 08:48 AM

Possibly =if(iserror(cell)... which will exclude all errors. Better to search why you have a DIV/0 and correct it

**contaminated** · 07-22-2010, 08:49 AM

why just not to use
=IF(ISERROR(A1),"Foo","Bar")

**mlittle74** · 06-20-2013, 02:41 PM

I was trying to do the same thing as the original OP. I couldn't correct the #DIV/0! because I was working on a data download I could not control. The responses helped me fix it easily. Thanks! You'd think #DIV/0! would return some sort of referenceable value though. Just curious at this point. Thanks again! You guys rock!