Try,

=ISERROR(A1)*1

Mike

"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