Forum Discussion
Excel Formula for displaying text based on sum of cell values (with ranges)
Hello,
Does anyone know of a good formula to be able to display a text value based on the sum of cell values for a table, with ranges?
E.g.
There is 25 cue types and if the count sums up to between 0-6 then "Difficult" is displayed instead of sum numerical value.
And if the count sums up to between 7-12 then "Moderate" is displayed instead of sum numerical value.
And the count sums up above 13 then "Easy" is displayed instead of sum numerical value.
- This would normally be approached by preparing a table of score thresholds and text descriptors. Then XLOOKUP (value or smaller) would return the corresponding text.
