IF function in Excel

IF returns one value if a test is TRUE and another if FALSE.

Syntax

=IF(logical_test, value_if_true, [value_if_false])

Argument	Required?	What it is
logical_test	Required	The condition to check, such as B2>=50.
value_if_true	Required	The result when the condition is TRUE.
value_if_false	Optional	The result when the condition is FALSE.

=IF(B2>=50,"Pass","Fail")

From the lesson IF Function.

Type the formula yourself and get it graded instantly, no Excel needed.

IF returns one value if a test is TRUE and another if FALSE.

=IF(logical_test, value_if_true, [value_if_false])

Argument	Required?	What it is
logical_test	Required	The condition to check, such as B2>=50.
value_if_true	Required	The result when the condition is TRUE.
value_if_false	Optional	The result when the condition is FALSE.

=IF(B2>=50,"Pass","Fail")

From the lesson IF Function.

Type the formula yourself and get it graded instantly, no Excel needed.