# Excel: Logical Functions

Functions in EnglishFunctions in FrenchDescription of Function
ANDETReturns TRUE if all of its arguments are TRUE.
BYCOLBYCOLApplies a LAMBDA to each column and returns an array of the results (365).
BYROWBYROWApplies a LAMBDA to each row and returns an array of the results (365).
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).
LAMBDALAMBDACreate custom, reusable functions and call them by a friendly name (365).
LETLETAssigns names to calculation results (365).
MAKEARRAYMAKEARRAYReturns a calculated array of a specified row and column size, by applying a LAMBDA (365).
MAPMAPReturns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new value (365).
NOTNONReverses the logic of its argument.
OROUReturns TRUE if any argument is TRUE.
REDUCEREDUCEReduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator (365).
SCANSCANScans an array by applying a LAMBDA to each value and returns an array that has each intermediate value (365).
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).