The pass rate is to be set at 60%.
A formula is to be entered at cell C4 to indicate whether the mark achieved is a pass or fail.
The formula would be:
=IF(B4>=60%,”Pass”,”Fail”)
This would mean that:
- If the result in cell B4 is equal to or greater than 60%, cell C4 would display “Pass”
- If the result in cell B4 is less than 60%, cell C4 would display “Fail”
Notice that any words to be displayed in the formula must be entered in speech marks (“).
Therefore, because the mark in cell B4 is 75%, the formula would return “Pass”. When copied down to the remaining cells, the formula would automatically change to check the content of cells B5, B6, B7 and B8.
