| AND | Returns TRUE if all the conditions are TRUE | | | |
| IN | Returns TRUE if the list of values being searched is in the array | | | |
| ISBLANK | Returns the logical value TRUE if the value argument is a reference to an empty cell | ISBLANK(value) | Returns TRUE if AC is empty | ISBLANK(AC) |
| ISEMPTY | Returns the logical value TRUE if the value argument is a reference to an empty cell | ISEMPTY(value) | Returns TRUE if AC has no value | ISEMPTY(AC) |
| ISNUMBER | Returns the logical value TRUE if the value argument is a valid number | ISNUMBER(value) | Returns AC-PY/PY if the value is a number else returns 0 | IF(ISNUMBER((AC-PY)/PY), (AC-PY)/PY , 0) |
| NOT | Changes FALSE to TRUE and TRUE to FALSE | NOT( logical_test ) | Will return 50 if the region is not West otherwise returns 25 | IF(NOT(Region == "West"), 50, 25) |
| OR | Returns TRUE if any of the arguments are TRUE and FALSE only if all arguments are FALSE | OR( logical_test1, [logical_test2], ... ) | Will return 25 if the region is West or East otherwise returns 30 | IF(OR(Region == "West", Region =="East"), 25, 30) |
| XOR | Returns a logical 'Exclusive OR' of all the arguments | XOR( logical_test1, [logical_test2], ... ) | Will return 25 for all category in the West except for category Urban, and returns 25 for all Urban category under all region except for west, for all other items returns 30 | IF(XOR(Region == "West", Category=="Urban"), 25, 30) |