Excel Logic / Conditional (IF, AND, OR, NOT, ISNA, ISERR, ISBLANK)

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