Logical functions

How to use the BYROW function

The BYROW function puts values from an array to a LAMBDA function row-wise. The LAMBDA function calculates new values based […]

How to use the BYCOL function

The BYCOL function passes all values in a column based on an array to a LAMBDA function, the LAMBDA function […]

How to use the SCAN function

The SCAN function passes all values in an array to a LAMBDA function, the LAMBDA function calculates new values based […]

How to use the MAP function

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 […]

How to use the XOR function

What is the XOR function? The XOR function calculates the exclusive OR. It was introduced in Excel 2013. What is […]

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 […]

How to use the NOT function

What is the NOT function? The NOT function returns the Boolean opposite to the given argument. TRUE returns FALSE and […]

How to use the TRUE function

What is the TRUE function? The TRUE function returns the logical (Boolean) value TRUE. What is a Boolean value? A […]

How to use the FALSE function

What is the FALSE function? The FALSE function returns the logical (boolean) value FALSE. What is a Boolean value? A […]

How to use the IFNA function

What is the IFNA function? The IFNA function handles #N/A errors only, it returns a value you specify if the […]

How to use the IFS function

The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first […]

How to use the OR function

The OR function allows you to carry out a logical test in each¬†argument and if at least one argument returns […]

How to use the AND function

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 […]

How to use the IF function

Checks if a logical expression is met. Returns a specific value if TRUE and another specific value if FALSE.