getiing a certain value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm building a portfolio and I want to return an
A+ if a value of a cell is greater than 9
A if a value is between 93-9
A- if a value is between 90-9
and so on for about 12 ranges

what formula do I use or can this even be done
 
Bonealley

Example only........

=VLOOKUP(B1,{30,"F";40,"E";50,"D";60,"C";70,"C+";80,"B";90,"B+";100,"A"},2)

B1 is the score. For a column of scores just drag/copy the formula down.

Adapt to your ranges of scores/grade letters.

Gord Dibben XL2002
 
Back
Top