Can you combine an If(ISBLANK with OR

Tina

The formulas below work independently. I would like them to work together with an OR function to Check a box. Every combination I try is not working.

=IF(ISBLANK(Role@row), 0, 1)

=IF(Level@row <> 2, 0, 1) 

Any assistance you can offer is appreciated.

Thank you!

Kelly Moore

This one is working consistently on my sheet. Try this

=IF(OR(Role@row = "", Level@row <> 2), 0, 1)

Kelly

Kelly Moore

Try this

=IF(OR(ISBLANK(Role@row), Level@row <> 2), 0, 1)

Tina

Hi KDM,

I tried the formula. It is accepted but it won't check the box for either part. This one is tricky. If you have any other thoughts please let me know.

Thank you!

Kelly Moore

This one is working consistently on my sheet. Try this

=IF(OR(Role@row = "", Level@row <> 2), 0, 1)

Kelly

Tina

Thanks KDM! I appreciate all your help.