Excel logical functions
Logical functions in Excel, explained with live examples.
19 logical functions in Excel — 19 documented in depth so far, the rest indexed below and landing every week.
Documented logical functions
Syntax, examples, and the equivalent — ready now.
- ANDReturns TRUE if all of its arguments are TRUELogicalGoogle Sheets
- BYCOLApplies a LAMBDA to each column and returns an array of the resultsLogicalGoogle Sheets
- BYROWApplies a LAMBDA to each row and returns an array of the resultsLogicalGoogle Sheets
- FALSEReturns the logical value FALSELogicalGoogle Sheets
- IFSpecifies a logical test to performLogicalGoogle Sheets
- IFERRORReturns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formulaLogicalGoogle Sheets
- IFNAReturns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expressionLogicalGoogle Sheets
- IFSChecks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.LogicalGoogle Sheets
- LAMBDACreate custom, reusable and call them by a friendly nameLogicalGoogle Sheets
- LETAssigns names to calculation resultsLogicalGoogle Sheets
- MAKEARRAYReturns a calculated array of a specified row and column size, by applying a LAMBDALogicalGoogle Sheets
- MAPReturns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new valueLogicalGoogle Sheets
- NOTReverses the logic of its argumentLogicalGoogle Sheets
- ORReturns TRUE if any argument is TRUELogicalGoogle Sheets
- REDUCEReduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulatorLogicalGoogle Sheets
- SCANScans an array by applying a LAMBDA to each value and returns an array that has each intermediate valueLogicalGoogle Sheets
- SWITCHEvaluates 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.LogicalGoogle Sheets
- TRUEReturns the logical value TRUELogicalGoogle Sheets
- XORReturns a logical exclusive OR of all argumentsLogicalGoogle Sheets
More Excel function categories