Excel 2007 : Problems using ISERROR with other comparisons in OR function

[timothyk]

Hello,

I am getting an #N/A error when using both the ISERROR and A2=0 in the same OR function. When the conditions are used separately, they work as desired.

I'm trying to test a certain cell (A2 on "Bom" sheet) for the following conditions:

• If it contains a 0 (zero)
  If it is blank
  If it has an error

The formula I am using is as follows:

Please Login or Register  to view this content.

This formula will work correctly if the cell A2 on "Bom" is blank or 0, but if the cell is #N/A it then breaks my formula.

If I remove the "Bom!A2=0" part of the formula, it then works with both blanks and #N/A errors.

It seems that I cannot successfully have either the ISERROR/ISBLANK functions in the OR function along with any direct comparisons (Bom!A2=0)

Any help with this is greatly appreciated.

Thank you

[Andrew-R]

The problem is that the check to see if A2 is 0 will itself generate an error, which you're not trapping.

How about:

=IF(AND(Input!J26=1,IFERROR(OR(ISBLANK(Bom!A2),Bom!A2=0),TRUE)),TRUE,FALSE)

[timothyk]

The problem is that the check to see if A2 is 0 will itself generate an error, which you're not trapping.

How about:

=IF(AND(Input!J26=1,IFERROR(OR(ISBLANK(Bom!A2),Bom!A2=0),TRUE)),TRUE,FALSE)

That does it! Thank you for your quick response!