Help with IF Formula


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


Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!