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
Best Answer
-
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
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!