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

don't understand

2 Answer(s)


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.


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


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