hlookup function

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Hi.Can anybody help me to solve this problem with hlookup function?

I have a worksheet with students' midterm grade.The instructor would
like to see what would be the impact of using a Progressive Curve on
the Midterm grade.
If student misses Exam and has a zero ? then keep it at zero
If student has a grade 1-119 points, increase their grade by 25 points
If student has a grade 120-125 points, increase their grade by 20
points
If student has a grade 126-131 points, increase their grade by 16
points
If student has a grade 132-139 points, increase their grade by 14
points
If student has a grade 140-145 points, increase their grade by 12
points
If student has a grade 146-153 points, increase their grade by 10
points
If student has a grade 154-159 points, increase their grade by 8
points
If student has a grade 160-165 points, increase their grade by 6
points
If student has a grade 166-173 points, increase their grade by 4
points
If student has a grade 174-179 points, increase their grade by 3
points
If student has a grade 180-185 points, increase their grade by 2
points
If student has a grade 186-200 points, increase their grade by 1 point

Thanks a lot!


--
ahiru
------------------------------------------------------------------------
ahiru's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32968
View this thread: http://www.excelforum.com/showthread.php?threadid=527930

.

Relevant Pages

  • Re: Great expectations...by students in the USA. They expect A grade or B grade at least...
    ... Grade inflation isn't just a US problem. ... student sample, there are one or two really "bo chap" types who really ... are held after the teaching evaluation. ...
    (soc.culture.singapore)
  • Re: gifted programs in your area
    ... in elementary school. ... considered for enrollment in the first grade if the following criteria ... Link Parent Questionnaire Fill-in ... The parent indicates permission for the student ...
    (misc.kids)
  • Re: Setting up tables for grades
    ... In my subform, I have a datasheet with two columns, Course and Grade. ... Course is a combo box with CourseID as its control sourse (from ... tblCourseGrades), its row source is tblCourses, its bound column is 1, it is ... Student shows up and is assigned to a class. ...
    (microsoft.public.access.forms)
  • Re: For loop
    ... another and then when they don;t to exit the loop, ... have to determine the amount of grades to be entered first. ... Read a number for the first student ... Calculate average grade for the students ...
    (comp.lang.java.programmer)
  • Re: complex regex
    ... > file contains students information as follow: ... > GRADE MATH COMPUTER HISTORY GOVERNEMENT ... > inserting information for the same student twice for one subject. ... to get rid of the newline character from the input, ...
    (comp.lang.perl.misc)