To get detailed information about a function, click its name in the first column.
Note: Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions. For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions.
|
Function |
Description |
|---|---|
|
Returns TRUE if all of its arguments are TRUE |
|
|
Returns the logical value FALSE |
|
|
Specifies a logical test to perform |
|
|
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula |
|
|
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression |
|
|
Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. |
|
|
Reverses the logic of its argument |
|
|
Returns TRUE if any argument is TRUE |
|
|
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. |
|
|
Returns the logical value TRUE |
|
|
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.
