Help with formula

L

Lynx10

I need help with a formula, If I insert my grade as 92-100 in cell A1,
need it to show in cell A2 that that is an "A" grade, if I insert m
grade as 89-91, It needs to be a "A-" grade, 86-88="b", etc..
 
B

Bryan Hessey

Hi,

If you have 7 or less conditions you can use


=IF(A1>91,"A",IF(A1>88,"A-",IF(A1>85,"B",IF(A1>79,"B-",IF(A1>69,"C",IF(A1>64,"C-",IF(A1>40,"D","E")))))))

If you have more conditions you will need a table and use
vlookup(a1,{table-ref},2,true) to select the required range from the
second column based on the best fit of column A

Hope this helps
 
R

Ragdyer

Try this in A2:

=LOOKUP(A1,{0,71,74,77,80,83,86,89,92;"E","D-","D","C-","C","B-","B","A-","A
"})

Change the values and letter grades to suit.
 
Top