Forum Discussion
Solved
Excel Formula Help
Good morning, I need a cell to show the word “High” or “Medium” or “Low” depending on the number total in a particular cell. The particular cell has a number total (sum) of a range of cells. ...
=IFS(AND(A1>=0,A1<=71),"Low",AND(A1>=72,A1<=142),"Medium",AND(A1>=143,A1<=999),"High")
If the particular cell is A1 then you can apply this formula.
=IFS(AND(A1>=0,A1<=71),"Low",AND(A1>=72,A1<=142),"Medium",AND(A1>=143,A1<=999),"High")
If the particular cell is A1 then you can apply this formula.
That worked OliverScheurich ! Thank you so much for the quick reply.
I almost had it, just missing a few parentheses and commas!
