Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jacob
 
Posts: n/a
Default assigning value to a column based on a table of values

I am correcting an exam and I have automatically generated the score of the
students. These I have in columns. Further I have a translation code that
showes how a score relates to a grade. this is shown below. Here the interval
from min to max is the score that produce the grade. For example if the score
is between 2 and 5 the grade is 5.

How do I make the translation from score to grade automatically?

min max grade
0 2 3
2 5 5
5 6 6
6 7 7
7 8 8
8 11 9
11 18 10
18 23 11

Jacob
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default assigning value to a column based on a table of values

Just use

=VLOOKUP(E1,B2:C9,2)

where E1 holds the score to be graded, B2:C9 holds the max and grade
columns.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jacob" wrote in message
...
I am correcting an exam and I have automatically generated the score of

the
students. These I have in columns. Further I have a translation code that
showes how a score relates to a grade. this is shown below. Here the

interval
from min to max is the score that produce the grade. For example if the

score
is between 2 and 5 the grade is 5.

How do I make the translation from score to grade automatically?

min max grade
0 2 3
2 5 5
5 6 6
6 7 7
7 8 8
8 11 9
11 18 10
18 23 11

Jacob



  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default assigning value to a column based on a table of values

Your max values are the same as the min values for the next grade. If
someone has a score of 2 or 5, which grade would be awarded? Assuming
that it would be the higher grade, the following should do what you
want:

=VLOOKUP(A1,$H$2:$J$9,3,TRUE)

where I have assumed your table (with headings) occupies cells H1 to
J9, and that the raw score is in A1. You can enter the formula, say, in
B1 and copy down.

Hope this helps.

Pete

  #4   Report Post  
Posted to microsoft.public.excel.misc
Jacob
 
Posts: n/a
Default assigning value to a column based on a table of values

Thanks to you both

"Jacob" skrev:

I am correcting an exam and I have automatically generated the score of the
students. These I have in columns. Further I have a translation code that
showes how a score relates to a grade. this is shown below. Here the interval
from min to max is the score that produce the grade. For example if the score
is between 2 and 5 the grade is 5.

How do I make the translation from score to grade automatically?

min max grade
0 2 3
2 5 5
5 6 6
6 7 7
7 8 8
8 11 9
11 18 10
18 23 11

Jacob

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 07:16 PM
Lookup values in one column to return another [email protected] Excel Worksheet Functions 4 November 17th 05 10:42 PM
How to get the values using a condition refering to the other column ramana Excel Worksheet Functions 2 October 28th 05 12:54 PM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com Excel Worksheet Functions 9 July 31st 05 03:37 AM


All times are GMT +1. The time now is 10:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"