IF | =IF(logical_test, [value_if_true], [value_if_false]) | Checks whether a condition is met, and returns one value if TRUE and another value if FALSE |
AND | =AND(logical1, [logical2], …) | Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE |
OR | =OR(logical1, [logical2], …) | Checks whether any of the arguments are TRUE and returns TRUE or FALSE. Returns FALSE only if all arguments are false |
NOT | =NOT(logical) | Changes FALSE to TRUE and TRUE to FALSE |
ISNA | =ISNA(value) | Checks whether a value is #N/A, and returns TRUE or FALSE |
ISERR | =ISERR(value) | Checks whether a value is an error other than #N/A, and returns TRUE or FALSE |
ISBLANK | =ISBLANK(value) | Checks whether the reference is to an empty cell, and returns TRUE or FALSE |