Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Convert Letter Grades To Numbers `

  1. #1
    Join Date
    21st June 2007
    Posts
    2

    Convert Letter Grades To Numbers `

    Can anyone suggest a formula that would take letter grades (A, B, C, D, and E) and produce an average letter grade?

    For example, a student gets a D on one assignment and a B on another. I want a formula that will produce "C".

    Thanks!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Formula request: converting letter grades to numbers so they can be averaged.

    Hi Pyrrhonic,

    Welcome to Board!!

    Try,


    =CHAR(INT(SUMPRODUCT(CODE(A1:A2))/COUNTA(A1:A2)))

    Adjust the range.

    HTH

  3. #3
    Join Date
    21st June 2007
    Posts
    2

    Re: Formula request: converting letter grades to numbers so they can be averaged.

    Works like a charm! Thanks Kris!

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Formula request: converting letter grades to numbers so they can be averaged.

    Quote Originally Posted by Pyrrhonic
    Works like a charm! Thanks Kris!
    You are welcome!!

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Convert Number To Letter
    By mikec78 in forum Excel General
    Replies: 11
    Last Post: May 14th, 2008, 17:54
  2. Replies: 6
    Last Post: February 17th, 2008, 11:52
  3. Letter Equals Numbers
    By bobjones in forum Excel General
    Replies: 5
    Last Post: August 16th, 2007, 13:30
  4. VBA Convert Percentages to Grades
    By sugarbianca in forum Excel General
    Replies: 6
    Last Post: February 13th, 2007, 23:38

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
  •  
porno