Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Convert Letter Grades To Numbers `

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

  • #2
    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
    Kris

    ExcelFox

    Comment


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

      Works like a charm! Thanks Kris!

      Comment


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

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

        ExcelFox

        Comment

        Trending

        Collapse

        There are no results that meet this criteria.

        Working...
        X