Identifying Unstable Values

K

Ken

I have a column of numerical values of which a few return "#DIV/0!" as the
answer. How do I write an if then statement signaling those cells as such.
When I use the formula =IF(A1="#DIV/0!",1) attempting to return "1" as the
"value" in such cases it doesn't work.
 
J

JE McGimpsey

Ken said:
I have a column of numerical values of which a few return "#DIV/0!" as the
answer. How do I write an if then statement signaling those cells as such.
When I use the formula =IF(A1="#DIV/0!",1) attempting to return "1" as the
"value" in such cases it doesn't work.
Click to expand...

One way:

Assume your cell contains something like:

=A1/B1

Then:

=IF(B1=0,"undefined",A1/B1)
 
Top