|
New Family of AND and OR functions designed for Array Formulas.
Excel’s standard OR and AND functions do not generally work well in array formulas because they only return a single True or False rather than evaluating each row or column in the array in turn to return an array of True/False..
The SpeedTools functions OR.ROWS, OR.COLS, OR.CELLS, AND.ROWS, AND.COLS, and AND.CELLS are designed to simplify the use of logical functions in array and FILTER formulas and can be nested to build complex logical array expressions.
OR.COLS - Logical OR by columns
OR.CELLS - Logical OR by cell
OR.ROWS - Logical OR by rows
AND.COLS - Logical AND by columns
AND.CELLS - Logical AND by cell
AND.ROWS - Logical AND by rows
|
