Ask a Question Sign up for Free 117 Experts currently online. Ask Questions for Free!

convert number score to letter grade - Microsoft Excel

How can I convert the number scores of my students into letter grade? For example 91-100 is A, 81-90 is B, 71-80 is C etc. Thank you for your advice....

Results 1 to 9 of 9

  1. #1

    convert number score to letter grade

    How can I convert the number scores of my students into
    letter grade? For example 91-100 is A, 81-90 is B, 71-80
    is C etc. Thank you for your advice.
    fchoy
  2. #2

    Re: convert number score to letter grade

    "fchoy" <microsoft.com> wrote in message
    news:7e6401c40329$16c1f950$gbl... 

    Have a look at this thread. via Bob Umlas.

    From: BobUmlas ()
    Subject: Re: Vlookup also
    View: Complete Thread (3 articles)
    Original Format
    Newsgroups: microsoft.public.excel.worksheetfunctions
    Date: 1999/07/12


    Set up the table like this (5 rows, 2 columns)
    0 F
    60 D
    70 C
    80 B
    90 A
    Name these 5r x 2c "Grades" (Not required, but good practice).
    To find someone's grade using the value from column K, enter
    =VLOOKUP(K2,Grades,2)
    Where K2 is one of the grades. The 2 in the formula says to return the value
    from the 2nd column of the table called "Grades".

    http://www.google.com/groups?q=vlookup+grade+group:*excel&start=10&hl=en &lr=&ie=UTF-8&oe=UTF-8&c2coff=1&selm=OXMN5GNz%23GA.52%40cpmsnbbsa05&rnu m=19

    Regards,
    Kevin


    Kevin
  3. #3

    Re: convert number score to letter grade

    In say, Sheet1, set-up a grade table in A2:B6
    ------------------
    0 F
    50 D
    70 C
    80 B
    90 A

    The above table presumes a slight tweak to the grade criteria, i.e.:

    A: >=90
    B: >=80 to <90
    C: >=70 to <80
    D: >=50 to <70
    F: <50

    In Sheet2, assume the marks are in col A, A2 down
    ------------
    Put in B2: =VLOOKUP(A2,Sheet1!$A$2:$B$6,2,TRUE)
    Copy B2 down as many rows as there are data in col A

    Col B will return the grades according to the grade criteria specified
    --
    Rgds
    Max
    xl 97
    --
    Please respond, in newsgroup
    xdemechanik <at>yahoo<dot>com
    ---
    "fchoy" <microsoft.com> wrote in message
    news:7e6401c40329$16c1f950$gbl... 


    Max
  4. #4

    Re: convert number score to letter grade

    Hi Max:

    Thanks for the fast response. Will try it out.

    Francis
     
    criteria, i.e.: 
    criteria specified 
    message 
    fchoy
  5. #5

    Re: convert number score to letter grade

    Hi Kelvin:

    Thanks for the fast response. Will try it out.

    Francis
     
    message 
    practice). 
    enter 
    to return the value 
    q=vlookup+grade+group:*excel&start=10&hl=en&lr=&ie =UTF-
    8&oe=UTF-8&c2coff=1&selm=OXMN5GNz%23GA.52%
    40cpmsnbbsa05&rnum=19 
  6. #6

    Re: convert number score to letter grade

    Hi Kevin:

    Sorry I mispelled your name earlier. I tried you way and
    it worked! Thanks again.

    Regards

    Francis 
    message 
    practice). 
    enter 
    to return the value 
    q=vlookup+grade+group:*excel&start=10&hl=en&lr=&ie =UTF-
    8&oe=UTF-8&c2coff=1&selm=OXMN5GNz%23GA.52%
    40cpmsnbbsa05&rnum=19 
    fchoy
  7. #7

    Re: convert number score to letter grade

    Hi Max:

    I tried your method and it worked!
    Thanks very much again.

    Regards

    Francis
     
    criteria, i.e.: 
    criteria specified 
    message 
    fchoy
  8. #8

    Re: convert number score to letter grade

    Glad to hear that, Francis !
    Thanks for the feedback
    --
    Rgds
    Max
    xl 97
    --
    Please respond, in newsgroup
    xdemechanik <at>yahoo<dot>com
    ---
    "fchoy" <microsoft.com> wrote in message
    news:7cec01c40336$aea06100$gbl... 


    Max
  9. #9

    Re: convert number score to letter grade

    "fchoy" wrote ... 

    My pleasure, and thank you for reporting back to the group.

    Regards,
    Kevin



    Kevin

Similar Threads

  1. convert text to predefined number in single column
    By chlee72 in forum Microsoft Excel
    Replies: 2
    Last Post: 01-14, 02:16 PM
  2. osX up-grade?
    By ed in forum Microsoft Office for Mac
    Replies: 2
    Last Post: 09-25, 02:36 AM
  3. Replies: 3
    Last Post: 07-27, 02:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100