3 Replies Latest reply on May 15, 2014 4:00 PM by philmodjunk

    Help with If Statement with values between two other values

    billsayagh

      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