IF/OR/AND Statement
Hi I'd like to do a OR statement with 2 and Statements included - following formula is resulting in an error and I can' see why:
=IF(
OR(
AND([Due Time]@row = "EoD", [Needs Removing]@row = 0),
AND(Status@row = "Not Started", Done@row = 0),
"1", "2"))
Can some please take a look over it and advise why and amend.
Many thanks in advance.
Mike
Best Answer
-
You forgot to close out your OR statement (and have an extra closing parenthesis on the end of the formula as a result).
=IF(OR(AND(..........), AND(..........)), "1", "2")
Answers
-
You forgot to close out your OR statement (and have an extra closing parenthesis on the end of the formula as a result).
=IF(OR(AND(..........), AND(..........)), "1", "2")
-
Parenthesis blind - thanks very much @PaulNewcome that has worked as i'd hoped.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!