|
Logical Functions for Array Formulas
Excel provides the AND and OR functions to allow you to specify multiple conditions in a Formula or IF statement.
But Excel’s AND/OR functions evaluate all of the given arguments/parameters and return a single TRUE/FALSE answer. This makes them difficult to use in array formulas where you usually require a column, row or array of True/False answers.
SpeedTools provides a family of array-formula friendly AND/OR functions:
|
