LinkBack URL
About LinkBacks
It's really not clear to me how you're grading this. Perhaps in J2 and copy down,
=LOOKUP(H2/MAX($H$2:$H$20), {0,0.2,0.4,0.6,0.8}, {"E","D","C","B","A"})
That gives student 80% of max grade an A, 60% of max grade a B, ...
It's really not clear to me how you're grading this. Perhaps in J2 and copy down,
=LOOKUP(H2/MAX($H$2:$H$20), {0,0.2,0.4,0.6,0.8}, {"E","D","C","B","A"})
That gives student 80% of max grade an A, 60% of max grade a B, ...
Last edited by shg; 12-12-2007 at 02:17 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks