This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm trying to put together a formula where if a score was between a ranges it would return text i.e High, low etc - any idea how to do this?
For example
Where a score ranges between 16-20 it would return the value as High
Medium - range 6-10
Low - 3-5
I'm struggling to work out whether it can be done in one cell or do I need to do anything else?
Thanks in advance
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Try this one.
=IF(A2>20,"",IF(A2>=16,"High",IF(A2>=6,"Medium",IF(A2>=3,"Low",""))))
Or, if you want to avoid nested IF's, you could consider this:
=LOOKUP(A2,{0,3,6,16,21},{"","Low","Medium","High",""})
You are welcome:)
Wow, this has worked. Thank you so much for your help on this.