Forum Discussion
dylanryan
Feb 10, 2021Copper Contributor
AND,OR AND IF FUNCTIONS? HELP
i wish to express the following range of scores in a single cell that will then appear in type as either low, medium or high, based on a given score: Low 10-24, Medium 25-34, High 35-50 thi...
Detlef_Lewin
Feb 11, 2021Silver Contributor
=XLOOKUP(H8,{10,25,35},{"Low","Medium","High"},,-1,1)