How to use IF functions in the case of Marks or a Grade of a student.
1 Answer(s)
Kaushal
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.
Cheers!
Jan 31 2014 08:03 PM
=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.
Cheers!