Logical - Get Digital Help

What is the MAKEARRAY function? The MAKEARRAY function returns an array with a specific number of rows and columns calculated […]

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

What is the BYCOL function? The BYCOL function passes all values in a column based on an array to a […]

What is the SCAN function? The SCAN function passes all values in an array to a LAMBDA function, the LAMBDA […]

What is the MAP function? The MAP function is a new Excel 365 function that requires the LAMBDA function to […]

What is the REDUCE function? The REDUCE function shrinks an array to an accumulated value, a LAMBDA function is needed […]

What is the LAMBDA function? The LAMBDA function lets you build custom functions using only regular Excel functions, no VBA […]

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

What is the SWITCH function? The SWITCH function returns a given value determined by an expression and a list of […]

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

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

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

What is the OR function? The OR function allows you to carry out a logical test in each argument and if […]

The image above demonstrates the AND function with two logical expressions. If the value in column B is equal to […]

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.