IF function

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 the Score is greater than 50, the IF function returns “Pass”, else it returns “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”