Looking for Formula that traps a result
Posted on 2016-07-29
I'm looking for the formula that can trap a result and produce a specific text result. In other words, if I have 5 stages, stage 1 is between 1 and 20, stage 2 is 21-40, stage 3 is 41-60, stage 4 is 61-80 and stage 5 is 81-100. When the result, single number, falls within any of these ranges, the appropriate Stage is displayed.
Appreciate your help in advance.