Excel Logical functions

This article provide the lists of 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.

 

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)

 

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
(ie. returns FALSE is the supplied argument is TRUE and returns TRUE if the supplied argument is FALSE)

 

Functions Returning Constant Values
TRUE Simply returns the logical value TRUE
FALSE Simply returns the logical value FALSE

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment