student needing help w/vlookup function grading criteria

J

Julie

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
 
J

Julie

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top