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

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

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