# Nazarbayev University
Undergraduate Grading System

Combo Box Label | NU Undergraduate
Combo Box Order | 2

The Incomplete ("I") and Withdrawal ("W") letter grades will be given special consideration in the sense that those corresponding numerical grades will not be included in the mean and standard deviation calculations for the overall course grade. The other ranges and letter grades are arbitrary and can vary between departments and/or universities.

Numerical Grade Range | Letter Grade
--- | ---
[95-100] | A
[90-95) | A-
[85-90) | B+
[80-85) | B
[75-80) | B-
[70-75) | C+
[65-70) | C
[60-65) | C-
[55-60) | D+
[50-55) | D
[0-50) | F
Incomplete | I
Withdrawal | W

Excel formula to convert a numerical grade into the corresponding letter grade (the placeholder "CELL" will be replaced by the Excel cell that contains the numerical grade value, and all whitespaces will be removed from the formula) :

    IFERROR(
    IF( CELL >= 95 , "A"   ,
    IF( CELL >= 90 , "A-"  ,
    IF( CELL >= 85 , "B+"  ,
    IF( CELL >= 80 , "B"   ,
    IF( CELL >= 75 , "B-"  ,
    IF( CELL >= 70 , "C+"  ,
    IF( CELL >= 65 , "C"   ,
    IF( CELL >= 60 , "C-"  ,
    IF( CELL >= 55 , "D+"  ,
    IF( CELL >= 50 , "D"   ,
                     "F"   ))))))))))
                   , "N/A" )