Help with IF AND OR and CONTAINS in formula

marym

I am trying to check a checkbox column if another check box column in the row is checked AND another column in the row contains either of two values. I can't figure out if I should use CONTAINS or OR and how to nest the IF.

something like this.....

IF (AND (checkbox1@row,1), IF(text@row contains "A" or "B"),1)

Leibel S

@marym

Try this:

=IF(AND(checkbox1@marym@row = 1,OR(CONTAINS("A", text@row), CONTAINS("B", text@row))),1)

marym

Thanks, that worked!