Logical Functions

Function

Description

AND

Returns TRUE if all arguments are true

FALSE

Returns the logical value FALSE

IF

Indicates the logical inquiry to be performed

IFERROR

Calculates a specified output if an expression contains an error; otherwise returns the result of the expression

NOT

Reverts the logical value of an argument

OR

Returns TRUE if one of the arguments is true

TRUE

Returns the logical value TRUE

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial