software

I have a series of student test marks between 0 and 40. I have to turn
these into a national curriculum (UK) level. I have the grade
boundaries, but they are not linear.15=level3. 19=level4. 26=level 5.
34=level6. I can easily use an if function to level these scores,
however, I want to level them as 4.3, 6.1 etc. Short of using lookup
and making a table 50marks long with the appropriate levels next to it,
is there a way I can do this without cluttering up my sheet.

Any help would be appreciated

Phil--
teacherphil
------------------------------------------------------------------------
teacherphil's Profile: www.excelforum.com/member.php...oamp;userid=30495
View this thread: www.excelforum.com/showthread...hreadid=501491You realize you don't have to clutter up your sheet? You can put your
VLOOKUP table on another sheet by using a named range, and you can even hide
that sheet.
www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;teacherphilquot; gt;
wrote in message
...
gt;
gt; I have a series of student test marks between 0 and 40. I have to turn
gt; these into a national curriculum (UK) level. I have the grade
gt; boundaries, but they are not linear.15=level3. 19=level4. 26=level 5.
gt; 34=level6. I can easily use an if function to level these scores,
gt; however, I want to level them as 4.3, 6.1 etc. Short of using lookup
gt; and making a table 50marks long with the appropriate levels next to it,
gt; is there a way I can do this without cluttering up my sheet.
gt;
gt; Any help would be appreciated
gt;
gt; Phil
gt;
gt;
gt; --
gt; teacherphil
gt; ------------------------------------------------------------------------
gt; teacherphil's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30495
gt; View this thread: www.excelforum.com/showthread...hreadid=501491
gt;
A lookup is the way to go, you only create it once, it is easily
maintainable, it can be off the visible screenj or even in a different
worksheet.

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;teacherphilquot; gt;
wrote in message
...
gt;
gt; I have a series of student test marks between 0 and 40. I have to turn
gt; these into a national curriculum (UK) level. I have the grade
gt; boundaries, but they are not linear.15=level3. 19=level4. 26=level 5.
gt; 34=level6. I can easily use an if function to level these scores,
gt; however, I want to level them as 4.3, 6.1 etc. Short of using lookup
gt; and making a table 50marks long with the appropriate levels next to it,
gt; is there a way I can do this without cluttering up my sheet.
gt;
gt; Any help would be appreciated
gt;
gt; Phil
gt;
gt;
gt; --
gt; teacherphil
gt; ------------------------------------------------------------------------
gt; teacherphil's Profile:
www.excelforum.com/member.php...oamp;userid=30495
gt; View this thread: www.excelforum.com/showthread...hreadid=501491
gt;
You can also get Excel to fill the numbers 0 to 40 for you, so you only
have to type in what grades each score represents. You might want to
set the grades column as Text before you enter the data, so that 3.0
(if such a grade exists) does not show as just 3.

Petesee the select function
and either use the help facility, or google for samples

JimB
quot;Bob Phillipsquot; gt; wrote in message
...
gt; A lookup is the way to go, you only create it once, it is easily
gt; maintainable, it can be off the visible screenj or even in a different
gt; worksheet.
gt;
gt; --
gt;
gt; HTH
gt;
gt; RP
gt; (remove nothere from the email address if mailing direct)
gt;
gt;
gt; quot;teacherphilquot; gt;
gt; wrote in message
gt; ...
gt; gt;
gt; gt; I have a series of student test marks between 0 and 40. I have to turn
gt; gt; these into a national curriculum (UK) level. I have the grade
gt; gt; boundaries, but they are not linear.15=level3. 19=level4. 26=level 5.
gt; gt; 34=level6. I can easily use an if function to level these scores,
gt; gt; however, I want to level them as 4.3, 6.1 etc. Short of using lookup
gt; gt; and making a table 50marks long with the appropriate levels next to it,
gt; gt; is there a way I can do this without cluttering up my sheet.
gt; gt;
gt; gt; Any help would be appreciated
gt; gt;
gt; gt; Phil
gt; gt;
gt; gt;
gt; gt; --
gt; gt; teacherphil
gt; gt; ------------------------------------------------------------------------
gt; gt; teacherphil's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30495
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=501491
gt; gt;
gt;
gt;