IF Formula to convert numeric grades to letter grades with + and -?

[absinthe]

Hello all,

I need to convert grades from numbers to letters using a +/- scale. Here is the scale I have to use.

A+ 97-100
A 93-96.99
A- 90-92.99

B+ 87-89.99
B 83-86.99
B- 80-82.99

C+ 77-79.99
C 70-76.99

D 65-69.99
E <65

Any help is appreciated!

 

[LockeGarmin]

Here is a formula that I came up with.

=CHOOSE(MATCH(A1,{0,65,70,77,80,83,87,90,93,97}),"E","D","C","C+","B-","B","B+","A-","A","A+")

 

[Teeroy]

You could also use:

=LOOKUP(A1,{0,65,70,77,80,83,87,90,93,97;"E","D","C","C+","B-","B","B+","A-","A ","A+"})

 

[cyrilbrd]

Or with the use of a simple table such as:

Excel 2013
	A	B
1	0	E
2	65	D
3	70	C
4	77	C+
5	80	B-
6	83	B
7	87	B+
8	90	A-
9	93	A
10	97	A+
11
12
13
14
15	grade	89
16	result	B+
absinthe

Cell Formulas
Range	Formula
B16	=VLOOKUP(B15,A1:B10,2,TRUE)

 

[absinthe]

Thank you to everyone for your contributions! It really helped me see what I was doing wrong

 

[cyrilbrd]

Thank you to everyone for your contributions! It really helped me see what I was doing wrong

most welcome.