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 ...
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.