Pass or fail and Grade in Excel

=IF(E1>=210,"pass","fail")    

     
         * E1 - Total cell

         * 210 - pass mark

=IF(E1>=500,"A+",IF(E1>=400,"A",IF(E1>=300,"B+",IF(E1<=300,"fail"))))

         

          * E1 - Total cell

          *      >500 = A+

              499 - 400 = A

              399 - 300 = B+

                < 300 = fail