How to use IF functions in the case of Marks or a Grade of a student.

How to use IF function in the case of Marks of a student in a Report card.
How i need to put the formula if the student has scored Distinction(above 75%), First class, Second Class or Fail.

1 Answer(s)


Use this formula, replace A1 with the cell containing the percentage:
=IF(A1>=0.5,IF(A1>=0.6,IF(A1>=0.75,"Distinction","First Class"),"Second Class"),"Fail")
If you're not using percentage, remove the '0.' from 0.5, 0.6 and 0.75.