Here is a simple formula to help you to determine your students grade.

 

The formula is as follows:

=IF(C4>89,”A”,IF(C4>79,”B”, IF(C4>69,”C”,IF(C4>59,”D”,”F”))))

then copy it down to the remaining cells.

Advertisements