Help with formula

[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..

 

[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

 

[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.