If or not formula help

[notarobot]

I'm trying to create a formula that produces a certain value based on a list of options.

Essentially, I want to know whether a someone associated with a city should be placed in "Zone 1", "Zone 2", or "Zone 3". "Zone 1" and "Zone 2" have a set of values associated with them, and then "Zone 3" is everything else.

As an example, let's say Zone 1 represents a certain list of cities--Austin, New York, Philly, Zone 2 represents a certain list of cities--Seattle, Atlanta, Chicago, and Zone 3 is all other cities not listed in Zones 1 or 2.

Any help would be great!

 

[T. Valko]

Here's the nested IF based on these items:

Austin.....Zone 1
New York.....Zone 1
Philly.....Zone 1
Seattle.....Zone 2
Atlanta.....Zone 2
Chicago.....Zone 2

=IF(OR(A1={"Austin","New York","Philly"}),"Zone 1",IF(OR(A1={"Seattle","Atlanta","Chicago"}),"Zone 2","Zone 3"))

 

[notarobot]

Thanks!

 

[T. Valko]

You're welcome!