Hi,

If you have 7 or less conditions you can use


=IF(A191,"A",IF(A188,"A-",IF(A185,"B",IF(A179,"B-",IF(A169,"C",IF(A164,"C-",IF(A140,"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


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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=401756