web analytics

IF

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

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