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