Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is this POSSIBLE IN EXCEL ?
Hello! I have a list of 100 names and test scores, then a range of letter grades. Name Scores Joe 100 Billy 95 Max 65 John 49 Grades from100-95, will get a letter Grade A Grades from 94-80, will get a letter Grade B 79-65, will get a letter Grade C 64-50, will get a letter Grade D 49-0, will get a letter Grade F I wanted to know if there is a combination of function that will allow me to convert the scores to their corresponding letter grade. Possible without macros. Thanks -- donfettuccini ------------------------------------------------------------------------ donfettuccini's Profile: http://www.excelforum.com/member.php...o&userid=25168 View this thread: http://www.excelforum.com/showthread...hreadid=386634 |
#2
|
|||
|
|||
donfettuccini, have a look at Create a VLookup formula for a range of values
here http://www.contextures.com/xlFunctions02.html#Range -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "donfettuccini" wrote in message news:donfettuccini.1s2x6t_1121209548.6375@excelfor um-nospam.com... Hello! I have a list of 100 names and test scores, then a range of letter grades. Name Scores Joe 100 Billy 95 Max 65 John 49 Grades from100-95, will get a letter Grade A Grades from 94-80, will get a letter Grade B 79-65, will get a letter Grade C 64-50, will get a letter Grade D 49-0, will get a letter Grade F I wanted to know if there is a combination of function that will allow me to convert the scores to their corresponding letter grade. Possible without macros. Thanks -- donfettuccini ------------------------------------------------------------------------ donfettuccini's Profile: http://www.excelforum.com/member.php...o&userid=25168 View this thread: http://www.excelforum.com/showthread...hreadid=386634 |
#3
|
|||
|
|||
Assuming your names are in column A and your scores are in column B in C1
put GRADES in G1 put 0 in G2 put 50 in G3 put 65 in G4 put 80 in G5 put 95 and in H1 put F in H2 put D in H3 put C in H4 put B in H5 put A finally in C2 put this formula and copy down.......... =VLOOKUP(B2,$G$1:$H$5,2,TRUE) Vaya con Dios, Chuck, CABGx3 "donfettuccini" wrote in message news:donfettuccini.1s2x6t_1121209548.6375@excelfor um-nospam.com... Hello! I have a list of 100 names and test scores, then a range of letter grades. Name Scores Joe 100 Billy 95 Max 65 John 49 Grades from100-95, will get a letter Grade A Grades from 94-80, will get a letter Grade B 79-65, will get a letter Grade C 64-50, will get a letter Grade D 49-0, will get a letter Grade F I wanted to know if there is a combination of function that will allow me to convert the scores to their corresponding letter grade. Possible without macros. Thanks -- donfettuccini ------------------------------------------------------------------------ donfettuccini's Profile: http://www.excelforum.com/member.php...o&userid=25168 View this thread: http://www.excelforum.com/showthread...hreadid=386634 |
#4
|
|||
|
|||
Thanks a lot for the feedback, I got the formula to work. Thanks a lot Paul B and CLR. -- donfettuccini ------------------------------------------------------------------------ donfettuccini's Profile: http://www.excelforum.com/member.php...o&userid=25168 View this thread: http://www.excelforum.com/showthread...hreadid=386634 |
#5
|
|||
|
|||
If you do not want to use a table, you may use the following array function: The numbers in the rightmost brackets are the numerical codes equivalent to letter grades. =CHAR(SUM(--(A2{0,48,64,79,94})*--(A2<{50,65,80,95,101})*{70,68,67,66,65})) Where A2 has the number grade. enter the formula and press contrl + shift + enter. donfettuccini wrote: Thanks a lot for the feedback, I got the formula to work. Thanks a lot Paul B and CLR. -- donfettuccini ------------------------------------------------------------------------ donfettuccini's Profile: http://www.excelforum.com/member.php...o&userid=25168 View this thread: http://www.excelforum.com/showthread...hreadid=386634 |
#6
|
|||
|
|||
=CHAR(SUM(--(F28{0,48,64,79,94})*--(F28<{50,65,80,95,101})*{70,68,67,66,65}))
as array formula. |
#7
|
|||
|
|||
Just another variation...
=CHAR(65+(A2<95)+(A2<80)+(A2<65)+2*(A2<50)) HTH -- Dana DeLouis Win XP & Office 2003 "donfettuccini" wrote in message news:donfettuccini.1s2x6t_1121209548.6375@excelfor um-nospam.com... Hello! I have a list of 100 names and test scores, then a range of letter grades. Name Scores Joe 100 Billy 95 Max 65 John 49 Grades from100-95, will get a letter Grade A Grades from 94-80, will get a letter Grade B 79-65, will get a letter Grade C 64-50, will get a letter Grade D 49-0, will get a letter Grade F I wanted to know if there is a combination of function that will allow me to convert the scores to their corresponding letter grade. Possible without macros. Thanks -- donfettuccini ------------------------------------------------------------------------ donfettuccini's Profile: http://www.excelforum.com/member.php...o&userid=25168 View this thread: http://www.excelforum.com/showthread...hreadid=386634 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |