Complete List of Excel Logical Functions, References and Examples

Logic Functions in Excel check the data and return the result «TRUE» if the condition is true, and «FALSE» if not.

Here’s a full list of Built-In Logical Functions in Excel and their Descriptions below:

Click each of the function link to see detailed example.

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
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)
Functions Returning Constant Values
TRUE	Returns the logical value TRUE
FALSE	Returns the logical value 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, 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 2016 – not available in Excel 2016 for Mac)
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 2016 – not available in Excel 2016 for Mac)