Logical functions

Functions in EnglishFunctions in FrenchDescription of Function
ANDETReturns TRUE if all of its arguments are TRUE.
FALSEFAUXReturns the logical value FALSE.
IFSISpecifies a logical test to perform.
IFERRORSIERREURReturns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.
IFNASI.NON.DISPReturns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression (2013).
IFSSI.CONDITIONSChecks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition (2016).
NOTNONReverses the logic of its argument.
OROUReturns TRUE if any argument is TRUE.
SWITCHSI.MULTIPLEEvaluates 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 (2016).
TRUEVRAIReturns the logical value TRUE.
XOROUXReturns a logical exclusive OR of all arguments (2013).