I have a spreadsheet that gives error percentages in column F - I want to categorise these percentages into bands as follows -
0-10 Excellent
10-20 Good
20-60 Low
60-80 Very Low
80 and above Concern
I've made a start with the following, but the result is always Excellent, despite the figure in the F column. Can anyone help me with a correction or a more effective way of getting the desired outcome?
=IF(F5>=80%, "Concern", IF(F5>=60, "Very Low", IF(F5>=20, "Low", IF(F5>=10, "Good", IF(F5<10, "Excellent")))))
Bookmarks