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

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)