I have a column with the first three numbers of a zip code. Each of these zip
codes is in a particular zone, but it's not as easy as 00001-00004 = zone 1,
00005-00010 = zone 2...they're all over the place.

I need somehow to have in the zone column a function that says if the number
zip column falls into a particular set of ranges then zone # will = 2-12.

I just don't know how to set up a bunch of ranges. Without knowing how to
do it...my mind would say do something like IF(B1 = {001,300}, {467,567},
{855, 964}), "zone 1" - with the ranges being 001 to 300, 467 to 567, and so
on.

I know that's not the way to do it, of course...but that's what I need to
know.

Thanks so much