Need assistance with IF Or and IF Not formulas

Chris Downes

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!

Katie G

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))

Chris Downes

Thanks Katie! I just tried that and it doesn't work, still getting a syntax error.

Mike TV

@Chris Downes

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, "")

SWilson

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.