Help with IF, OR, NOT, ISBLANK

Lynn234 · 10/12/22

Hello, I'm trying to get it to check these columns and if even one of them is not blank, then populate "1" into the column:

=IF(OR(NOT(ISBLANK([WHS: Enter Date Received]@row)), NOT(ISBLANK([WHS: Enter Lot]@row)), NOT(ISBLANK([IQA: Inspector Email]@row)), 1, 0))

I keep getting the #incorrect argument error....

Any tips?

Thanks in advance!

Michael Culley · 10/12/22

I would just do:

=if(or([WHS: Enter Date Received]@row<>"",[WHS: Enter Lot]@row<>"",[IQA: Inspector Email]@row<>""),1,0)

Michael Culley · 10/12/22

Also I think the only issue with how you did it was the last 2 ))

I think you need to end your formula like this: ([IQA: Inspector Email]@row))), 1, 0)

Formulas and Functions