Nested ISERROR not working

[Tripp]

Hello,

I am trying to create a simple if function with two criteria:

=IF(OR(ISERROR(A4),A4=0), "BAD","GOOD")

But it only works for cells containing numbers and doesn't work with errors.

Everything works separately but not in my formula.

What am I missing?

Regards,

Tripp

 

[Tripp]

Is it perhaps that an error will always stop the A4=0 criteria from working?

 

[shrivallabha]

Is it perhaps that an error will always stop the A4=0 criteria from working?

Spot on! Error is masking the result you are looking for. You need to rewrite like below:
=IF(ISERROR(A4),"BAD",IF(A4=0,"BAD","GOOD"))

 

[bosco_yip]

On the other way, to test the data

1.1] If the data is numeric value and ignore 0 :

=IF(ISNUMBER(1/A4),"GOOD","BAD")

1.2] If the data is numeric value (include 0) :

=IF(ISNUMBER(A4),"GOOD","BAD")

2] If the data is text value :

=IF(ISTEXT(B4),"GOOD","BAD")

Regards
Bosco