Hi All,
I am looking to create a score sheet for monitoring attained grades. I have been trying to come up with various ways of arranging the below information but I am struggling. I have tried various IF functions but I have yet to find the correct formula.
Here is what I want to achieve
In cell A1 I will insert a score. In B1 I want excel to automatically insert a designated word.
If A1 is 0-10 I want B1 to say "Below"
If A1 is 11 - 20 I want B1 to say "Towards"
If A1 is 21 - 30 I want B1 to "At"
If A1 is 31 - 40 I want B1 to say "Above"
Can anyone help with this as I can't find a solution so far.
Cheers
Bookmarks