| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
student needing help w/vlookup function grading criteria
My look up table is in grading criteria one sheet set up as
Average Exam Grade 0.00 F ets one the following sheets are list of studnets with three exams each and an average of all scores cell E2 is the average of all scores. My formula is: VLOOKUP(E2,'GRADINGCRITERIA'!$A$2:B6,2,TRUE) i GET A LETTER GRADE BUT ALL THE STUDENTS MADE AN A. Even the f's. Help please |
|
#2
|
|||
|
|||
|
student needing help w/vlookup function grading criteria
Post the EXACT grading criteria table that you have setup.
Biff "Julie" wrote in message ... My look up table is in grading criteria one sheet set up as Average Exam Grade 0.00 F ets one the following sheets are list of studnets with three exams each and an average of all scores cell E2 is the average of all scores. My formula is: VLOOKUP(E2,'GRADINGCRITERIA'!$A$2:B6,2,TRUE) i GET A LETTER GRADE BUT ALL THE STUDENTS MADE AN A. Even the f's. Help please |
|
#3
|
|||
|
|||
|
student needing help w/vlookup function grading criteria
That was my problem. The setup grading criteria. Problem fixed. Thanks I
has put in ex:0-49 F 50-59 D, when I had two numbers it didn't work, and I eliminated and just put highest score for each grade ex: 49 F etc. Thanks. Julie "Biff" wrote: Post the EXACT grading criteria table that you have setup. Biff "Julie" wrote in message ... My look up table is in grading criteria one sheet set up as Average Exam Grade 0.00 F ets one the following sheets are list of studnets with three exams each and an average of all scores cell E2 is the average of all scores. My formula is: VLOOKUP(E2,'GRADINGCRITERIA'!$A$2:B6,2,TRUE) i GET A LETTER GRADE BUT ALL THE STUDENTS MADE AN A. Even the f's. Help please |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| for SUMIF function, how do I use 2 sets of range & criteria | Excel Worksheet Functions | |||
| using logical functions as criteria with the SUMIF function | Excel Worksheet Functions | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
| Grading Function Question... | Excel Worksheet Functions | |||
| Grading Function Question... | Excel Worksheet Functions | |||
Linear Mode
