Check for error.type in same cell

  • Thread starter Thread starter art
  • Start date Start date
A

art

Hello all:

Is it possible to use the formula Error.type to check if the cell has a
certain error? So, for example, in cell A1 I start with =if(error.type("the
cell itself with a formula")= 6, "yes","no"). Is this possible? To check for
the cell itself if the result of the formula results in an error it should
result to yes or no.

Thanks.

Art.
 
You can check whether the formula returns an error or not..

=IF(ISERROR(<formula>),"",<formula>)

If this post helps click Yes
 
You can check whether the formula returns an error or not..

=IF(ISERROR(<formula>),"",<formula>)

If this post helps click Yes
 
Back
Top