Which of these is not an argument of the IF function?
Answer & explanation
Correct answer: option 3
The correct answer is Option (3) → Value_when_false
The IF function takes three arguments: logical_test, value_if_true and value_if_false. It checks the logical test and returns the first value if the test is true and the second if it is false.
The recognised argument is “value_if_false”. Option (3) swaps if for when, so no such argument exists, and it is the odd one out. One small word changed and a real name turned fake, so read each function name letter by letter.
NCERT (2026-27 edition):
|

