IF(OR (ISBLANK)... HELP

Elizabeth Aird · 10/29/21

So I want a box to check IF any of the green boxes below are blank.

This isn't working... just trying to use 2 of the boxes.

=IF(OR(ISBLANK([1421 COATING WEIGHTS]@row), (ISBLANK([1310 CTG WEIGHT 1]@row), 1, 0)

Brett Wyrick · 10/29/21

Hey Elizabeth. Try this:

=IF(OR([1421 COATING WEIGHTS]@row="", [1310 CTG WEIGHT 1]@row=""), 1, 0)

Brett Wyrick · 10/29/21

Hey Elizabeth. Try this:

=IF(OR([1421 COATING WEIGHTS]@row="", [1310 CTG WEIGHT 1]@row=""), 1, 0)

Elizabeth Aird · 10/29/21

Brett,

That worked ..but now that I look at it I need it to check if both are blank..

so an AND statement instead?

Brett Wyrick · 11/08/21

@Elizabeth Aird yes, an AND statement would work there!

Best Answer