Excel Function

IF

Basic conditional branching function.

IF(logical_test, value_if_true, value_if_false)

Arguments

logical_test

Required

Enter a condition expression that returns TRUE/FALSE.

value_if_true

Required

Specify the value returned when logical_test is TRUE.

value_if_false

Required

Specify the value returned when logical_test is FALSE.

Practice Preview

show outputs based on conditions. Use IF to Basic conditional branching function. For logical_test, enter a condition expression that returns TRUE/FALSE. use C2>=80 for logical_test, use "合格" for value_if_true, use "不合格" for value_if_false. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=IF(C2>=80, "合格", "不合格")

Practice This Function

Practice in Sequential Mode Back to Function List