Logical Functions

Functions for logical operations and boolean logic

AND Function

The AND function is a fundamental logical tool in Excel that evaluates multiple conditions and returns TRUE only when every condition is met. It serves as a powerful building block for complex decision-making formulas, enabling multi-criteria analysis across worksheets.

BYCOL Function

The BYCOL function applies a LAMBDA function to each column of an array, returning a single-row array containing the results. This powerful dynamic array function enables column-wise processing of data ranges, making complex operations across multiple columns efficient and readable.

BYROW Function

The BYROW function applies a LAMBDA function to each row of an array, returning an array containing the results from each row. This enables row-wise processing of data arrays, transforming entire rows based on custom logic.

FALSE Function

The FALSE function returns the logical value FALSE. It's a simple, no-argument function primarily used for compatibility with other spreadsheet applications and as a clear way to insert the FALSE logical value in formulas.

IF Function

The IF function is Excel's fundamental decision-making tool that evaluates a condition and returns one value if true, another if false. As one of the most essential logical functions, it forms the foundation for conditional logic across all spreadsheet analysis.

IFS Function

The IFS function evaluates multiple conditions in sequence and returns the value associated with the first TRUE condition. It provides a cleaner alternative to deeply nested IF statements for complex decision-making logic.

LAMBDA Function

The LAMBDA function enables users to create custom, reusable functions directly in Excel formulas without VBA or macros. Define parameters and calculations once, then call by name throughout the workbook like native functions.

LET Function

The LET function creates temporary variables within a formula, storing intermediate calculations for reuse. This dramatically improves formula performance, readability, and maintainability by eliminating repetitive calculations and providing meaningful names for complex expressions.

MAKEARRAY Function

The MAKEARRAY function dynamically generates an array of specified dimensions by executing a LAMBDA function for each cell position. This powerful function enables the creation of complex calculated arrays without manual formula replication across ranges.

MAP Function

The MAP function transforms each element in one or more arrays by applying a custom LAMBDA function, returning a new array with the transformed values. Perfect for bulk data transformations without complex array formulas.

NOT Function

The Excel NOT function reverses the logical value of its argument. It returns TRUE when the input is FALSE and FALSE when the input is TRUE, making it essential for creating complex logical conditions and inverting test results in formulas.

OR Function

The OR function is a powerful logical tool that returns TRUE when at least one condition in a set of tests evaluates to TRUE. It's essential for creating flexible decision-making formulas that test multiple criteria simultaneously.

REDUCE Function

The REDUCE function transforms an array into a single accumulated value by iteratively applying a custom LAMBDA function to each element, starting from an optional initial value. This powerful array processing tool enables complex reductions like conditional sums, products, and custom aggregations.

SCAN Function

The SCAN function applies a LAMBDA function cumulatively to each element of an array, returning an array containing all intermediate results. Unlike REDUCE which returns only the final result, SCAN provides the complete sequence of accumulated values, making it perfect for creating running totals, cumulative products, and progressive calculations.

SWITCH Function

The Excel SWITCH function matches an expression against multiple values and returns the corresponding result for the first match. It provides a cleaner alternative to nested IF statements for exact value matching scenarios.

TRUE Function

The Excel TRUE function returns the logical value TRUE. This function is primarily provided for compatibility with other spreadsheet applications and is rarely needed since TRUE can be entered directly as a literal value in formulas.

XOR Function

The XOR function performs a logical exclusive OR operation across multiple conditions, returning TRUE only when an odd number of arguments evaluate to TRUE. This makes it perfect for detecting exactly one true condition among several tests.