IF/OR Functions

Aspasia Kalomoiri

=IF(OR(AND([Column2]@row = "yellow", [Column4]@row <> ""), IF(AND([Column2]@row = "green", [Column4]@row <> ""))), true)

Hi everyone,

I want my column to be checked, when either yellow or green is appeared in [Column2] and when [Column4] is empty in both cases.

Can someone tell me what I am doing wrong?

Thanks!

Aspa

Chris Mondeau

Hi Aspasia! Looks like the order of your or/and might need some adjustment. Try giving this a shot!

=IF(AND(ISBLANK([Column4]@row), OR([Column2]@row = "Green", [Column2]@row = "Yellow")), 1, 0)

Chris Mondeau

Hi Aspasia! Looks like the order of your or/and might need some adjustment. Try giving this a shot!

=IF(AND(ISBLANK([Column4]@row), OR([Column2]@row = "Green", [Column2]@row = "Yellow")), 1, 0)

Aspasia Kalomoiri

Hi cmondo,

Thant worked perfectly, it is exactly what I was looking for!

Thank you so much!

Aspasia