Formulas with letters

[johannaclark]

Hi,

I'm sure this has come up before, but I can't find it anywhere! I'm a teacher ad I need to work out if my pupils have met their target grade or not. For example, I have column B with target grades A*- G + U and and test results also as letters further along. I need a column that returns the results +1 if they are 1 above, = if they are no target, or -1 etc if they are below. Any helpers?

[pecoflyer]

Hi and welcome to the board
could you please post a small sample sheet ( no pics please) showing what you have and expected results.
Thx

[johannaclark]

It's ok - I've just worked it out! I gave each grade a numerical reference (A*=1) etc, did a vlookup table =LOOKUP(D2,$L$10:$M$18), then a IF to compare the two =IF(E2=C2,"+",IF(E2<C2,"+",IF(E2>C2, "-")))
Bingo!

[pecoflyer]

Thank you for sharing
You can also shorten a bit =IF(E2>C2, "-","+")