Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
assign value to range
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I assign range to variant and use | Excel Discussion (Misc queries) | |||
Assign a Name to a Range in VBA | Excel Programming | |||
assign value to range in VBA function | Excel Programming | |||
assign a value to a range | Excel Discussion (Misc queries) | |||
Assign a random selection to a range | Excel Programming |