FunctionDescriptionFormularAND functionReturns TRUE if all of its arguments are TRUEBYCOL functionApplies a LAMBDA to each column and returns an array of the resultsBYROW functionApplies a LAMBDA to each row and returns an array of the resultsFALSE functionReturns the logical value FALSEIF functionSpecifies a logical test to performIFERROR functionReturns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formulaIFNA functionReturns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expressionIFS functionChecks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.LAMBDA functionCreate custom, reusable functions and call them by a friendly nameLET functionAssigns names to calculation resultsMAKEARRAY functionReturns a calculated array of a specified row and column size, by applying a LAMBDAMAP functionReturns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new valueNOT functionReverses the logic of its argumentOR functionReturns TRUE if any argument is TRUEREDUCE functionReduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulatorSCAN functionScans an array by applying a LAMBDA to each value and returns an array that has each intermediate valueSWITCH functionEvaluates 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.TRUE functionReturns the logical value TRUEXOR functionReturns a logical exclusive OR of all arguments
