Excel Logical Functions
This page lists the built-in Excel logical functions. These functions include the boolean operators and conditional tests, which will be an essential part of many working spreadsheets.
The functions have been 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 first introduced in Excel 2007 or Excel 2013 and so are not available in earlier versions of Excel.
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|
(ie. returns FALSE is the supplied argument is TRUE and returns TRUE if the supplied argument is 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)|
|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