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

Value-when-false

The correct answer is option 4- Value-when-false.

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, the second if your comparison is False. The IF function has three arguments:

• Logical-test: This is the condition that is evaluated. If the condition is true, the function returns the value-of-true argument. If the condition is false, the function returns the value-of-false argument.

• Value-of-true: This is the value that is returned if the logical-test is true.

• Value-of-false: This is the value that is returned if the logical-test is false.

Therefore, the argument Value-when-false is not an argument of the IF function.