The range_lookup argument is either True, or False. With False, you get?


0
don't understand

2 Answer(s)


0

IF function uses 3 parameters -
1) Logical_test
2) Value_if_true
3) Value_if_false

- If the logical test fails that is the condition is not satisfied, Excel will put the false value.

A simple example.

=IF(Marks>40,"PASS","FAIL")

Here, if the student has not scored more than 40, that is condition is False, the False value that is FAIL is displayed.

0

The Value displayed in case of a "TRUE/ FALSE" condition will be "FALSE" if the value to be populated does not fall under the matched criteria