Logical functions help you to work the logical values, TRUE and FALSE. They include boolean operators, conditional tests and functions to return the constant logical values.

FunctionCategoryDescription
ANDBoolean OperatorReturns TRUE if all of its arguments are TRUE
FALSEConstant ValueReturns the logical value FALSE
IFConditionalSpecifies a logical test to perform
IFERRORConditionalReturns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula (New in Excel 2007)
IFNAConditionalReturns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression (New in Excel 2013)
NOTBoolean OperatorReverses the logic of its argument
ORBoolean OperatorReturns TRUE if any argument is TRUE
TRUEConstant ValueReturns the logical value TRUE
XORBoolean OperatorReturns a logical exclusive OR of all arguments (New in Excel 2013)