IF(AND(OR

Sharon Castiglia

Hello,

I am trying to turn a traffic light green based on the following criteria:

EMV Ready? = Yes

Payment Platform from Dispensers can only include Gilbarco FlexPay II and Gilbarco FlexPay IV.

Trying the following and getting an #INCORRECT ARGUMENT SET

=IF(AND([EMV Ready?]@row = "Yes", [Payment Platform from Dispenser]@row = "Gilbarco FlexPay IV", [Payment Platform from Dispenser]@row = "Gilbarco FlexPay II", "Green", "Red"))

Have tried using IF(AND(OR and didn't have much luck

Any help would be appreciated.

Sharon

Mike Wilday

Try this:

=IF(AND([EMV Ready?]@row = "Yes", OR([Payment Platform from Dispenser]@row = "Gilbarco FlexPay IV", [Payment Platform from Dispenser]@row = "Gilbarco FlexPay II")), "Green", "Red")

You have to close the AND statement and Include the OR embedded in the And statement and close them both before you can do the THEN, ELSE statements.

Let me know if that solved your issue.

Mike Wilday

Try this:

=IF(AND([EMV Ready?]@row = "Yes", OR([Payment Platform from Dispenser]@row = "Gilbarco FlexPay IV", [Payment Platform from Dispenser]@row = "Gilbarco FlexPay II")), "Green", "Red")

You have to close the AND statement and Include the OR embedded in the And statement and close them both before you can do the THEN, ELSE statements.

Let me know if that solved your issue.

Sharon Castiglia

Thank you so much. I struggle with IF(AND(OR statements. Starting to get a little clearer each time though.

Mike Wilday

Absolutely! Glad I could help.

Basically any And statement has to be enclosed AND( this, that) and any OR Statement has to be enclosed OR(This, that) before you can jump into the rest of the IF statement. But if you put one in inside the other, you have to close them both before completing the OR statement.

AND(this, this, OR(this, that))

https://help.smartsheet.com/function/and

https://help.smartsheet.com/function/or