Help with If Statement with values between two other values
I have a set of zip codes that i am trying to organize by zone.
ie: If zip code is between 00001 < Zip Code < 19999 then result is zone 1
and If zip code is between 20000 < Zip Code < 29999 then result is zone 2
and If zip code is between 30000 < Zip Code < 39999 then result is zone 3
and If zip code is between 40000 < Zip Code < 49999 then result is zone 4 etc...