+ Reply to Thread
Results 1 to 5 of 5

Converting a Number score to an equivalent Letter score

  1. #1
    Registered User
    Join Date
    09-24-2008
    Location
    Georgia
    Posts
    4

    Converting a Number score to an equivalent Letter score

    Ok so I have a test in a couple of hours and I cannot get this formula to work properly. It's a teachers grade sheet of all the students and their grades for each test. What I want to do is have a column that depending on their numerical grade will give me a corresponding letter grade. I know it's an IF function but I can't figure out how to string them together. Can someone please help!!
    Attached Files Attached Files
    Last edited by cgurr1; 09-24-2008 at 12:01 PM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902
    You can create a table on the side with the bottoms of the grade ranges listed in ascending order... in the next column insert the corresponding Letter grades.

    Then use a Vlookup() formula with TRUE 4th argument to retrieve the values.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    09-24-2008
    Location
    Georgia
    Posts
    4
    How would it know that if its greater than 80 but less that 90 to render a B and when its just greater than 80 (say 93) to render an A. I've tried =IF(AND(... but what I can't figure out is how to do multiple sections in one function. Like if B2 is >=90, then A, if <90 but >=80, then B, if <80 but >=70, then C, if <70, then D. That's what I want it to do but I don't know how to talk computer for it.

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902
    Try:

    =Lookup(A1,{0,70,80,90},{"D","C","B","A"})

    where A1 contains the numerical score.

  5. #5
    Registered User
    Join Date
    09-24-2008
    Location
    Georgia
    Posts
    4
    Wow my teacher must be retarted. That is SOOO much easier. Thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Strange problem when converting number to XML
    By Yesil Timsah in forum Excel General
    Replies: 0
    Last Post: 01-10-2007, 09:09 AM
  2. letter to number Help?
    By JLascola in forum Excel General
    Replies: 2
    Last Post: 12-31-2006, 09:33 AM
  3. Converting Number to Date
    By cpadude in forum Excel General
    Replies: 1
    Last Post: 10-27-2006, 12:02 PM
  4. Replies: 4
    Last Post: 09-22-2006, 04:05 PM
  5. Converting number in to %
    By mangesh in forum Excel General
    Replies: 6
    Last Post: 09-22-2006, 02:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1