ExcelFunctions.net
Excel Logical Functions
Home »
Excel-Built-In-Functions »
Excel-Logical-Functions
This page lists the current, built-in Excel Logical Functions. These functions are provided by Excel, to
help you to work the logical values, TRUE and FALSE. They 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 to perform
a specific task. Selecting a function name will take you to a full description of the function, with
examples of use.
Excel Logical Functions List
|
Boolean Operator Functions
|
|
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
|
|
NOT
|
Returns a logical value that is the opposite of a user supplied logical value or expression
(ie. returns FALSE is the supplied argument is TRUE and returns TRUE if the supplied
argument is FALSE)
|
|
|
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 the function returns
a supplied value; Otherwise the function returns the initial value.
(New in Excel 2007)
|
|
Functions Returning Constant Values
|
|
TRUE
|
Simply returns the logical value TRUE
|
|
FALSE
|
Simply returns the logical value FALSE
|
|
More information about the Excel Logical Functions, and examples of use are provided on the
Microsoft Support Website
