How to use Logical Functions (reference)

To find more in-depth information about how to use logical functions, select its name in the first column.

An example of how to use logical functions - FALSE.
© Excel Easy, 2020.

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.

Note: Version markers reflect the version of Excel a function was introduced. These functions are only found in later versions. For example, a version marker of 2013 means that this function is available in Excel 2013 and all later versions. It is important to bear this in mind for you when learning about how to use logical functions for your particular purpose.

Functions Table

AND functionReturns TRUE if all of its arguments are TRUE
FALSE functionReturns the logical value FALSE
IF functionSpecifies a logical test to perform
IFERROR functionReturns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
IFNA function
Excel 2013
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression
IFS function
Excel 2016
Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
NOT functionReverses the logic of its argument
OR functionReturns TRUE if any argument is TRUE
SWITCH function
Excel 2016
Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.
TRUE functionReturns the logical value TRUE
XOR function
Excel 2013
Returns a logical exclusive OR of all arguments

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

See Also

Excel functions (by category)

Excel functions (alphabetical)

Leave a Reply

%d bloggers like this: