Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |