Help with IF Formula

hawk2023

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

Kelly Moore

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

Kelly Moore

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

hawk2023

Thanks so much @Kelly Moore !