To find more in-depth information about how to use logical functions, select its name in the first column.
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.
|AND function||Returns TRUE if all of its arguments are TRUE|
|FALSE function||Returns the logical value FALSE|
|IF function||Specifies a logical test to perform|
|IFERROR function||Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula|
|IFNA function||Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression|
|IFS function||Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.|
|NOT function||Reverses the logic of its argument|
|OR function||Returns TRUE if any argument is TRUE|
|SWITCH function||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 function||Returns the logical value TRUE|
|XOR function||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.