Help with IF, OR, NOT, ISBLANK

Lynn234

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

I would just do:

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

Michael Culley

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)