Home • Software Application • Microsoft Excel Apr 13th, 2013 at 05:32 PM

How to calculate grading in Excel?

You have to write the following formula (assuming that data in column d6,e6,h6):

=IF(OR(D6<14,E6<14),"F",

       IF(AND(H6>=90,H6<=100),"A",

          IF(AND(H6>=80,H6<=89),"B",

              IF(AND(H6>=70,H6<=79),"C",

                  IF(AND(H6>=60,H6<=69),"D",

                       IF(AND(H6>=50,H6<=59),"E","F")
                  )
             )
         )
     )
)