Logical functions (reference)

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.

Click one of the links in the following list to see detailed help about the function.

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

Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression

NOT function

Reverses the logic of its argument

OR function

Returns TRUE if any argument is TRUE

TRUE function

Returns the logical value TRUE

XOR function

Returns a logical exclusive OR of all arguments

See Also

Excel functions (by category)

Excel functions (alphabetical)

Applies To: Excel 2013, Excel 2007, Excel 2010, Excel Starter, Excel Online, Excel 2016 for Mac



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language