Which of these is not an argument of the IF function?

The correct answer is Option (4) → Value-when-false

The IF function has three arguments: logical_test (the condition checked), value_if_true (returned when the condition is TRUE) and value_if_false (returned when it is FALSE). There is no argument called value-when-false.

Option (1) Logical-test — An argument of IF. It is the condition that is tested, such as A1<20.

Option (2) Value-if-false — An argument of IF. It is the value returned when the test is FALSE.

Option (3) Value-if-true — An argument of IF. It is the value returned when the test is TRUE.