The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect.
So an IF statement can have two results. The first result is if your comparison is True, and the second if your comparison is False.
=IF(logical_test,[value_if_true],[value_if_false])
Example
If the Score is greater than 50, the IF function returns “Pass”, else it returns “Fail”.
=IF(B2>50,”Pass”,”Fail”)
- Type “IF(=”
- Click “fx” in the formula bar.
- In “logical_test“, click on cell “B2” then type “>50”
- In “value_if_true”, type “Pass”
- In “value_if_false”, type “Fail”
- Click on “OK”
- Drag from “B2 to B8”