Logical functions (reference)

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

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
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 function

Reverses the logic of its argument

OR function

Returns 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 function

Returns 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)

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×