Help with formula
 

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


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

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

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Lynx10" wrote in
message ...

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


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