đ
Logical Functions
10 functionsConditional logic, branching, and decision-making in formulas
AND
AND checks if ALL conditions are TRUE.
FALSE
Returns the logical value FALSE.
IF
IF checks a condition and returns different values based on whether it is true or false.
IFERROR
IFERROR catches errors and returns a custom value instead.
IFNA
Replaces #N/A errors with a fallback value.
IFS
A simpler way to write multiple IF statements without nesting.
NOT
NOT flips TRUE to FALSE and FALSE to TRUE.
OR
OR checks if ANY condition is TRUE.
TRUE
Returns the logical value TRUE.
XOR
Returns TRUE when an odd number of arguments are TRUE.