Identifying Unstable Values

[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.

 

[JE McGimpsey]

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.

One way:

Assume your cell contains something like:

=A1/B1

Then:

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