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.
Assuming the number being compared is in A2, then
Open in new window