IF function with many conditions

I have an internal client who wants to parse a list of 100 different zip codes, and depending on the zip, assign another text field into a different field.

In other words, IF zip code = 11733 OR 11725 OR 11890 (and so on) THEN assign to New York.

Maybe there is a way other than using IF?

Thanks for any help you can provide,

Grace Barry

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!