Binny
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.
Apr 27 2014 07:56 PM