Logical Functions
This page lists the current, built-in Excel logical functions. These functions return one of the logical values, TRUE or FALSE.
The Excel logical functions include boolean operators, conditional tests and functions to return the constant logical values.
The functions have been grouped into categories, to help you to find the function you need. Selecting a function name will take you to a full description of the function, with examples of use.
Boolean Operator Functions
-
-
XOR
Returns a logical Exclusive Or of all arguments
Conditional Functions
-
-
IF
Tests a user-defined condition and returns one result if the condition is TRUE, and another result if the condition is FALSE
-
IFERROR
Tests if an initial supplied value (or expression) returns an error, and if so, returns a supplied value; Otherwise the function returns the initial value.
-
IFNA
Tests if an expression returns the #N/A error and if so, returns an alternative specified value; Otherwise the function returns the value of the supplied expression
Functions Returning Constant Values
-