Home »
Excel-Built-In-Functions »
Excel-Logical-Functions
Excel Logical Functions
The Excel logical functions include the boolean operators and conditional tests.
All the Excel logical functions are listed below, grouped into categories, to help you
to find the function you need. Each function name links to a full description of the
function, with examples of use.
Note that some of the Logical functions were introduced in recent versions of Excel,
and so are not available in earlier versions.
Excel Logical Functions List
|
AND
|
Tests a number of user-defined conditions and returns TRUE if ALL of the
conditions evaluate to TRUE, or FALSE otherwise
|
|
OR
|
Tests a number of user-defined conditions and returns TRUE if ANY
of the conditions evaluate to TRUE, or FALSE otherwise
|
|
XOR
|
Returns a logical Exclusive Or of all arguments (New in Excel 2013)
|
|
NOT
|
Returns a logical value that is the opposite of a user supplied logical value or expression
(i.e. returns FALSE is the supplied argument is TRUE and returns TRUE if the
supplied argument is FALSE)
|
|
|
|
TRUE
|
Returns the logical value TRUE
|
|
FALSE
|
Returns the logical value FALSE
|
|
|
|
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.
(New in Excel 2007)
|
|
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.
(New in Excel 2013)
|
|
IFS
|
Tests a number of supplied conditions and returns a result corresponding to the first
condition that evaluates to TRUE.
(New in Excel 2019)
|
|
SWITCH
|
Compares a number of supplied values to a supplied test expression and returns a
result corresponding to the first value that matches the test expression.
(New in Excel 2019)
|
|
More details on the Excel Logical Functions are provided on the
Microsoft Support Website