Skip to Content
 AND
AND(logical1, [logical2], ...)
 BYCOL
BYCOL(array, lambda)
 BYROW
BYROW(array, lambda)
 FALSE
FALSE()
 IF
IF(logical_test, [value_if_true], [value_if_false])
 IFERROR
IFERROR(value, value_if_error)
 IFNA
IFNA(value, value_if_na)
 IFS
IFS(logical_test1, value_if_true1, ...)
 LAMBDA
LAMBDA([parameter1, ...], calculation)
 LET
LET(name1, name_value1, ..., calculation)
 MAKEARRAY
MAKEARRAY(rows, cols, lambda)
 MAP
MAP(array1, [array2, ...], lambda)
 NOT
NOT(logical)
 OR
OR(logical1, [logical2], ...)
 REDUCE
REDUCE([initial_value], array, lambda)
 SCAN
SCAN([initial_value], array, lambda)
 SWITCH
SWITCH(expression, value1, result1, ...)
 TRUE
TRUE()
 XOR
XOR(logical1, [logical2], ...)

Logical

Logical functions perform operations on logical values.