AnsweredAssumed Answered

Help with If Statement with values between two other values

Question asked by billsayagh on May 15, 2014
Latest reply on May 15, 2014 by philmodjunk

Title

Help with If Statement with values between two other values

Post

     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...

     I would like to know if there is a way to create a script or statement that would do the following. Any help with the matter would be greatly appreciated. I hit a wall and can't move forward angry

Outcomes