Pass or fail with IF

The IF function lets you add conditional logic to your spreadsheets. It checks a condition and returns one value if true, another if false:

=IF(logical_test, value_if_true, value_if_false)

For example, =IF(A1 > 50, "Yes", "No") checks if A1 is greater than 50 and returns either "Yes" or "No."

Your task

A group of students took a test. They pass if their score is higher than 60. The scores are in cells B2 through B6.

Use the IF function in cell C2 to output "Pass" or "Fail" for the first student. Then copy your formula down to C6 so it applies to all 5 students.

Copying a formula down

Once you've entered a formula in a cell, you can copy it to the cells below. Select the cell, then hover over the small square at the bottom-right corner of the cell (the fill handle). Drag it down to fill the formula into the rows below. Excel automatically adjusts the cell references for each row.