Pass fail result including absent is fail [Closed]

Report
-
One student passed in 5 papers out of 6 papers but 1 paper absent in this exam.actually this student is fail.How to calculate the result in excel