Help with IF Formula

✭✭

Hi,

I am trying to take a column of zip codes and create a new column that categorizes the zip code into one of 5 NY Neighborhoods. I tried writing my formula out but am stuck. Here is the data:

I tried in excel, and in my excel the first cell with a zip is J\$7\$. Any thoughts? Thanks! :)

Tags:

• ✭✭✭✭✭✭

Hey @hawk2023

Try this

=IF(AND(Zip@row>=10001, Zip@row<=10282), "Manhattan", IF(AND(Zip@row>=10301, Zip@row<=10314), "Staten Island", IF(AND(Zip@row>=10451, Zip@row<=10457), "Bronx", IF(OR(AND(Zip@row>=11004, Zip@row<=11109), AND(Zip@row>=11351, Zip@row<=11697)),"Queens", IF(AND(Zip@row>=11201, Zip@row<=11256), "Brooklyn")))))

Will it work for you?

Kelly

• ✭✭✭✭✭✭

Hey @hawk2023

Try this

=IF(AND(Zip@row>=10001, Zip@row<=10282), "Manhattan", IF(AND(Zip@row>=10301, Zip@row<=10314), "Staten Island", IF(AND(Zip@row>=10451, Zip@row<=10457), "Bronx", IF(OR(AND(Zip@row>=11004, Zip@row<=11109), AND(Zip@row>=11351, Zip@row<=11697)),"Queens", IF(AND(Zip@row>=11201, Zip@row<=11256), "Brooklyn")))))

Will it work for you?

Kelly

• ✭✭

Thanks so much @Kelly Moore !

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!