# using OR and multiple expressions

✭✭✭✭✭

I created this statement using OR and CONTAINS to select a value between 2 expressions - Stage 1 or Stage 2:

=IF(OR(CONTAINS("Stage 1", Function@row), CONTAINS("Stage 2", Function@row)), IF([Example Result]@row >= -30, 1))

This works fine for recognizing and providing results for Stage 1 & 2 logical expressions.

I want to add a 3rd logical expression (Stage 3) but I am getting INCORRECT ARGUMENT SET errors:

=IF(OR(CONTAINS("Stage 1", Function@row), CONTAINS("Stage 2", Function@row), CONTAINS("Stage 3", Function@row), IF([Example Result]@row >= -30, 1)))

I thought i was able have more than 2 logical expressions using the OR statement.

Appreciate any help and thanks.

RickG

• ✭✭✭✭✭✭

Hey @Rick Girard

It looks like a parenthesis is missing to close off the OR statement.

=IF(OR(CONTAINS("Stage 1", Function@row), CONTAINS("Stage 2", Function@row), CONTAINS("Stage 3", Function@row)), IF([Example Result]@row >= -30, 1))

Will this work for you

Kelly

• ✭✭✭✭✭✭

Hey @Rick Girard

It looks like a parenthesis is missing to close off the OR statement.

=IF(OR(CONTAINS("Stage 1", Function@row), CONTAINS("Stage 2", Function@row), CONTAINS("Stage 3", Function@row)), IF([Example Result]@row >= -30, 1))

Will this work for you

Kelly

• ✭✭✭✭✭

Thank you Kelly, i hate when that happens ! Devil is in the details , right ?

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!