|
Name
|
Description
|
Syntax
|
AND
|
|
|
Returns TRUE if all of its arguments are TRUE; returns FALSE if one or more arguments evaluate to FALSE.
|
AND(logical1, [logical2], …)
|
FALSE
|
|
Returns the logical value FALSE.
|
FALSE()
|
IF
|
|
Checks a condition and returns one result if the condition is TRUE, and another result if the condition is FALSE.
|
IF(logical_test, [value_if_true], [value_if_false])
|
IFS
|
|
Checks one or more conditions and returns a value of the first TRUE condition. If no TRUE conditions are found, this function returns #N/A error.
|
IFS([logical_test, value_if_true, ,…)
|
IFERROR
|
|
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.
|
IFERROR(value, value_if_error)
|
IFNA
|
|
Returns a value you specify if a formula returns the #N/A error value; otherwise it returns the result of the formula.
|
IFNA(value, value_if_na)
|
NOT
|
|
Reverses the logical value of its argument.
|
NOT(logical)
|
OR
|
|
Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.
|
OR(logical1, [logical2], …)
|
SWITCH
|
|
Evaluates an expression against a list of values and returns the result of the first matching value. You can provide a default value to return if there is no match. If there are no matching values and no default argument is supplied, the function returns the #N/A! error.
|
SWITCH(expression, value1, result1, default_or_value2, result2,…)
|
TRUE
|
|
Returns the logical value TRUE.
|
TRUE()
|
XOR
|
|
Returns a logical exclusive OR of all arguments.
|
XOR(logical1, [logical2],…)
|
|