Logical functions
The BYROW function puts values from an array to a LAMBDA function row-wise. The LAMBDA function calculates new values based […]
The BYCOL function passes all values in a column based on an array to a LAMBDA function, the LAMBDA function […]
The SCAN function passes all values in an array to a LAMBDA function, the LAMBDA function calculates new values based […]
The MAP function passes all values in an array to a LAMBDA function, the LAMBDA function calculates new values based […]
How to use the REDUCE function
The REDUCE function shrinks an array to an accumulated value, a LAMBDA function is needed to properly accumulate each value […]
How to use the LAMBDA function
The LAMBDA function lets you build custom functions using only regular Excel functions, no VBA is needed. These custom functions […]
The XOR function was introduced in Excel 2013 and calculates the logical exclusive OR meaning if at least one of the […]
How to use the SWITCH function
The SWITCH function returns a given value determined by an expression and a list of values. If the expression matches […]
The NOT function returns the boolean opposite to the given argument. TRUE returns FALSE and FALSE returns TRUE. Formula in […]
Returns the logical (boolean) value TRUE. Excel Function Syntax TRUE() Arguments The TRUE function has no arguments. Comments Excel interprets […]
The FALSE function returns the logical (boolean) value FALSE. Table of Contents FALSE function Syntax FALSE function Arguments FALSE function […]
The IFNA function handles #N/A errors only, it returns a given value you specify if the formula returns a #N/A […]
The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first […]
The OR function allows you to carry out a logical test in each argument and if at least one argument returns […]
The image above demonstrates the AND function with two logical expressions. If the value in column B is equal to […]
How to use the IFERROR function
The IFERROR function lets you catch most errors in Excel formulas. It was introduced in Excel 2007. In previous Excel […]
Checks if a logical expression is met. Returns a specific value if TRUE and another specific value if FALSE.