Excel function category
Excel Logical Functions
Reference pages for functions that help spreadsheets make decisions, test conditions, and return different results based on logic.
5 functions
AND
Logical
Return TRUE if all supplied conditions evaluate to TRUE.
Syntax
AND(logical1, [logical2], ...)Used in 2 articlesView reference
IF
Logical
Test a condition and return one result for TRUE and another for FALSE.
Syntax
IF(logical_test, value_if_true, [value_if_false])Used in 15 articlesView reference
IFS
Logical
Evaluate multiple conditions and return the result for the first TRUE condition.
Syntax
IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)Used in 1 articleView reference
OR
Logical
Return TRUE if any supplied condition evaluates to TRUE.
Syntax
OR(logical1, [logical2], ...)Used in 2 articlesView reference
SWITCH
Logical
Match an expression against a list of values and return the result for the first match.
Syntax
SWITCH(expression, value1, result1, [value2, result2], ..., [default])Used in 1 articleView reference