| 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 |
| 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 | |||
Threaded Mode
