Need assistance with IF Or and IF Not formulas
current formula has syntax errors : IF(OR(Region@row = "a", Region@row = "b", Region@row = "c", Region@row = "d", Region@row = "e"), "email1", IF(OR(Region@row = "F", Region@row = "g", Region@row = "h", Region@row = "SMA"), "email2"), If(NOT(Region@row="a", region@row="b", region@row="c"), [departmentdirectoremail]@row, ""))
Basically, I want to be able to say, anything that falls in regions a-e = "email1", anything regions f-SMA = "email2", and anything that is not one of those regions = cell reference in that row.
Any ideas? Where am I going wrong?
Thanks!
Answers
-
Hi Chris, you're so close! There was a minor issue with the parenthesis after "email2". then since you've already ruled out a/b/c in the first IF statement, I think you can just skip that and show the other cell at that time.
Try this and see if it does what you want:
=IF(OR(region@row = "a", region@row = "b", region@row = "c", region@row = "d", region@row = "e"), "email1", IF(OR(region@row = "F", region@row = "g", region@row = "h", region@row = "SMA"), "email2", departmentdirectoremail@row))
-
Thanks Katie! I just tried that and it doesn't work, still getting a syntax error.
-
IF(OR(Region@row = "a", Region@row = "b", Region@row = "c", Region@row = "d", Region@row = "e"), "email1", IF(OR(Region@row = "F", Region@row = "g", Region@row = "h", Region@row = "SMA"), "email2", If(NOT(Region@row="a", region@row="b", region@row="c"), [departmentdirectoremail]@row, "")
-
As Katie said, your parens were off. Her syntax is correct.
You can try screenshotting the actual sheet and your formula. You may have a typo or other simple error we can't see here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!