software

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: www.excelforum.com/member.php...oamp;userid=32968
View this thread: www.excelforum.com/showthread...hreadid=527930Hi!

Create a 2 column table like this:

0 0
1 25
120 20
126 16
132 14
140 12
146 10
154 8
160 6
166 4
174 3
180 2
186 1Assume that table is in the range F1:G13

A1 = grade points

=VLOOKUP(A1,F1:G13,2)

Biff

quot;ahiruquot; gt; wrote in
message ...
gt;
gt; Hi.Can anybody help me to solve this problem with hlookup function?
gt;
gt; I have a worksheet with students' midterm grade.The instructor would
gt; like to see what would be the impact of using a Progressive Curve on
gt; the Midterm grade.
gt; If student misses Exam and has a zero - then keep it at zero
gt; If student has a grade 1-119 points, increase their grade by 25 points
gt; If student has a grade 120-125 points, increase their grade by 20
gt; points
gt; If student has a grade 126-131 points, increase their grade by 16
gt; points
gt; If student has a grade 132-139 points, increase their grade by 14
gt; points
gt; If student has a grade 140-145 points, increase their grade by 12
gt; points
gt; If student has a grade 146-153 points, increase their grade by 10
gt; points
gt; If student has a grade 154-159 points, increase their grade by 8
gt; points
gt; If student has a grade 160-165 points, increase their grade by 6
gt; points
gt; If student has a grade 166-173 points, increase their grade by 4
gt; points
gt; If student has a grade 174-179 points, increase their grade by 3
gt; points
gt; If student has a grade 180-185 points, increase their grade by 2
gt; points
gt; If student has a grade 186-200 points, increase their grade by 1 point
gt;
gt; Thanks a lot!
gt;
gt;
gt; --
gt; ahiru
gt; ------------------------------------------------------------------------
gt; ahiru's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32968
gt; View this thread: www.excelforum.com/showthread...hreadid=527930
gt;
Ooops!

I overlooked the fact that you want to add this value to the grade points,
so:

=A1 VLOOKUP(A1,F1:G13,2)

Biff

quot;Biffquot; gt; wrote in message
...
gt; Hi!
gt;
gt; Create a 2 column table like this:
gt;
gt; 0 0
gt; 1 25
gt; 120 20
gt; 126 16
gt; 132 14
gt; 140 12
gt; 146 10
gt; 154 8
gt; 160 6
gt; 166 4
gt; 174 3
gt; 180 2
gt; 186 1
gt;
gt;
gt; Assume that table is in the range F1:G13
gt;
gt; A1 = grade points
gt;
gt; =VLOOKUP(A1,F1:G13,2)
gt;
gt; Biff
gt;
gt; quot;ahiruquot; gt; wrote in
gt; message ...
gt;gt;
gt;gt; Hi.Can anybody help me to solve this problem with hlookup function?
gt;gt;
gt;gt; I have a worksheet with students' midterm grade.The instructor would
gt;gt; like to see what would be the impact of using a Progressive Curve on
gt;gt; the Midterm grade.
gt;gt; If student misses Exam and has a zero - then keep it at zero
gt;gt; If student has a grade 1-119 points, increase their grade by 25 points
gt;gt; If student has a grade 120-125 points, increase their grade by 20
gt;gt; points
gt;gt; If student has a grade 126-131 points, increase their grade by 16
gt;gt; points
gt;gt; If student has a grade 132-139 points, increase their grade by 14
gt;gt; points
gt;gt; If student has a grade 140-145 points, increase their grade by 12
gt;gt; points
gt;gt; If student has a grade 146-153 points, increase their grade by 10
gt;gt; points
gt;gt; If student has a grade 154-159 points, increase their grade by 8
gt;gt; points
gt;gt; If student has a grade 160-165 points, increase their grade by 6
gt;gt; points
gt;gt; If student has a grade 166-173 points, increase their grade by 4
gt;gt; points
gt;gt; If student has a grade 174-179 points, increase their grade by 3
gt;gt; points
gt;gt; If student has a grade 180-185 points, increase their grade by 2
gt;gt; points
gt;gt; If student has a grade 186-200 points, increase their grade by 1 point
gt;gt;
gt;gt; Thanks a lot!
gt;gt;
gt;gt;
gt;gt; --
gt;gt; ahiru
gt;gt; ------------------------------------------------------------------------
gt;gt; ahiru's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=32968
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=527930
gt;gt;
gt;
gt;
gt; ...The instructor would
gt; like to see what would be the impact
gt; of using a Progressive Curve on...

Just a fun observation. I would be a little upset if I got a 120, but
another student who got a 119 ends up with a better grade.
119 -gt; 144
120 -gt; 140

--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;ahiruquot; gt; wrote in
message ...
gt;
gt; Hi.Can anybody help me to solve this problem with hlookup function?
gt;
gt; I have a worksheet with students' midterm grade.The instructor would
gt; like to see what would be the impact of using a Progressive Curve on
gt; the Midterm grade.
gt; If student misses Exam and has a zero - then keep it at zero
gt; If student has a grade 1-119 points, increase their grade by 25 points
gt; If student has a grade 120-125 points, increase their grade by 20
gt; points
gt; If student has a grade 126-131 points, increase their grade by 16
gt; points
gt; If student has a grade 132-139 points, increase their grade by 14
gt; points
gt; If student has a grade 140-145 points, increase their grade by 12
gt; points
gt; If student has a grade 146-153 points, increase their grade by 10
gt; points
gt; If student has a grade 154-159 points, increase their grade by 8
gt; points
gt; If student has a grade 160-165 points, increase their grade by 6
gt; points
gt; If student has a grade 166-173 points, increase their grade by 4
gt; points
gt; If student has a grade 174-179 points, increase their grade by 3
gt; points
gt; If student has a grade 180-185 points, increase their grade by 2
gt; points
gt; If student has a grade 186-200 points, increase their grade by 1 point
gt;
gt; Thanks a lot!
gt;
gt; --
gt; ahiru

Thanks so much for your help!--
ahiru
------------------------------------------------------------------------
ahiru's Profile: www.excelforum.com/member.php...oamp;userid=32968
View this thread: www.excelforum.com/showthread...hreadid=527930You're welcome!

Biff

quot;ahiruquot; gt; wrote in
message ...
gt;
gt; Thanks so much for your help!
gt;
gt;
gt; --
gt; ahiru
gt; ------------------------------------------------------------------------
gt; ahiru's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32968
gt; View this thread: www.excelforum.com/showthread...hreadid=527930
gt;