Return a custom result when a formula generates a #N/A error
=IFNA(value, value_if_na)
Return a custom result when a formula generates an error
=ISERROR(value)
Return different TRUE and FALSE results from logical tests
=IF(logical_test,[value_if_true],[value_if_false])
Return TRUE or FALSE statements based on testing multiple logical conditions
=AND(logical1, [logical2], ...)
Return TRUE or FALSE statements based on testing multiple logical conditions
=OR(logical1, [logical2], ...)
Return the reverse of TRUE or FALSE statements based on testing logical conditions
=NOT(logical)
Logical Functions
Latest Additions
TEXTJOIN() function
26 March 2022
REPLACE() function
26 March 2022
TEXT() function
26 March 2022
RANK.AVG() function
25 March 2022
CONCAT() function
22 March 2022
CHAR() function
21 March 2022