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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!