Trying to do:
IF(Cell=#DIV/0!, "Foo", "Bar")
doesn't seem to work
Trying to do:
IF(Cell=#DIV/0!, "Foo", "Bar")
doesn't seem to work
Possibly =if(iserror(cell)... which will exclude all errors. Better to search why you have a DIV/0 and correct it
why just not to use
=IF(ISERROR(A1),"Foo","Bar")
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks