Function 3 – IF

The IF function checks whether a condition is met, and returns one value if true and another value if false.

Explanation: if the score is greater than or equal to 60, the IF function returns Pass, else it returns Fail. Remember, to quickly copy this formula to the other cells, click on the lower right corner of cell C2 and drag it down to cell C6.