AnsweredAssumed Answered

Case using a range of numbers

Question asked by user13722 on Jun 9, 2016
Latest reply on Jun 9, 2016 by 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

Outcomes