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! :)
Best 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?
Kelly
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!