2 Replies Latest reply on Jun 9, 2016 11:38 PM by user13722

    Case using a range of numbers

    user13722

      I want to write a calculation using CASE - I want to  select a field and if that field number is entered between 1-19 I want the calculation to return number 1, if that number entered  is between 20-25 i would like itr to return return number 2, if that number is between 21-30 return number 3, etc all the way to 1000 variations. I see that IF is not the way to go but I can not make Case work using a range of numbers. Any help would save me a LOT. Thanks