Hi,

Excel contains 7 built-in error types of which DIV/0 is one, the others are
Error Type#
#NULL! 1
#DIV/0! 2
#VALUE! 3
#REF! 4
#NAME? 5
#NUM! 6
#N/A 7

You can trap these with the following functions:
=ISERR(A1)
=ISNA(A1)
=ISERROR(A1)
=ERROR.TYPE(A1)

You usually combine on of the above with an IF statement such as
=IF(ISERR(A1),"",A1)
However, it is common when you get a DIV/0 message to consider what is
causing that and trapping that rather than the error itself, for example
If A1=0 the formula =B1/A1 would return the DIV/0 error, so we would trap
the value of A1 as follows:
=IF(A1=0,"",B1/A1)
In this case if A1 is blank or 0, the formula will show nothing in the cells.

--
Thanks,
Shane Devenshire


"Ken" wrote:

I apologize if someone already saw or answered this question ... I can't find
which subcategory of Excel groups where it apparently was posted earlier.
My question is how can you write an if then statement that recognizes that
the cell has an unstable answer. When I use the statement,
IF(A1="#DIV/0!",1), the cell doesn't return the value of "1" when the values
are unstable. How would I do this?
--
Ken