IF AND

Sam Walsh

I am trying to narrow my conditional formatting for an order dependent on 2 different parts---

I created 2 condition columns for a line item, First Condition Column "Y/N" and Second Condition Column "Y/N"

...and in a third column "Required" I simply want and IF/ AND formula to say IF First Condition Column is "Yes" and IF Second Condition Column is "Yes" at the row---THEN the Required Column will be "Yes" at the row ----IF either First or Second are "No" or both are "No" THEN the Required Column would indicate "No"

=IF(AND([First Condition]@row "Yes", [Second Condition]@row "Yes", "Yes", "No")

Thanks in advance!

Jeff Reisman

@Sam Walsh You were close! You need = signs in the logical statements, and you need to close off the AND statement with an end parentheses:

=IF(AND([First Condition]@row = "Yes", [Second Condition]@row = "Yes"), "Yes", "No")

Jeff Reisman

@Sam Walsh You were close! You need = signs in the logical statements, and you need to close off the AND statement with an end parentheses:

=IF(AND([First Condition]@row = "Yes", [Second Condition]@row = "Yes"), "Yes", "No")

Sam Walsh

Perfect! Thank you!