Forum Discussion
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.
Here is what I want, and I am at a loss, tried everything I know…
If the total in the particular cell is between 0 and 71, then show word “Low”
If the total in the particular cell is between 72 and 142, then show word “Medium”
If the total in the particular cell is between 143 and 999, then show word “High”
Thank you!
Windows 10
Microsoft 365
Version 2312
=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.
2 Replies
=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!
