Navigation: FXLV4SpeedTools > Logical Functions for Array Formulas >

Examples of SpeedTools Logical Functions:

 

 

 

Examples of SpeedTools Logical Functions:

Row Functions

The OR.ROWS formula is array-entered (Control-Shift-Enter) in the column as

{=OR.ROWS(A2:A21,B2:B21,C2:C21)}

The AND.ROWS formula is array-entered (Control-Shift-Enter) in the column as

{=AND.ROWS(A2:A21,B2:B21,C2:C21)}

The functions have evaluated each row of the data to produce a corresponding True/False

Data

 

OR.ROWS

AND.ROWS

TRUE

FALSE

FALSE

 

TRUE

FALSE

FALSE

TRUE

FALSE

 

TRUE

FALSE

FALSE

FALSE

TRUE

 

TRUE

FALSE

TRUE

TRUE

TRUE

 

TRUE

TRUE

FALSE

FALSE

FALSE

 

FALSE

FALSE

fred

joe

bill

 

FALSE

FALSE

1

FALSE

FALSE

 

TRUE

FALSE

FALSE

-1

FALSE

 

TRUE

FALSE

FALSE

FALSE

0.001

 

TRUE

FALSE

TRUE

TRUE

TRUE

 

TRUE

TRUE

TRUE

joe

bill

 

TRUE

FALSE

fred

TRUE

bill

 

TRUE

FALSE

fred

joe

TRUE

 

TRUE

FALSE

FALSE

joe

bill

 

FALSE

FALSE

fred

FALSE

bill

 

FALSE

FALSE

fred

joe

FALSE

 

FALSE

FALSE

FALSE

TRUE

FALSE

 

TRUE

FALSE

TRUE

0

FALSE

 

TRUE

FALSE

 

 

 

 

FALSE

FALSE

 

 

 

 

FALSE

FALSE

Column Functions:

Data

TRUE

FALSE

FALSE

1

TRUE

FALSE

-1

FALSE

0

1

TRUE

0

 

 

 

{=AND.COLS(A55:C58)}

TRUE

FALSE

FALSE

{=OR.COLS(A55:C58)}

TRUE

TRUE

FALSE

The functions have evaluated each column of the data to produce a corresponding True/False

CELL Functions:

{=OR.CELLS($A$2:$C$21,$E$2:$G$19)}

{=AND.CELLS($A$2:$C$21,$E$2:$G$19)}

The functions have evaluated each corresponding element in the 2 data tables to produce a corresponding array of True/False.

 

Data

 

More Data

 

OR.CELLS

 

AND.CELLS

TRUE

FALSE

FALSE

 

FALSE

FALSE

TRUE

 

TRUE

FALSE

TRUE

 

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

 

FALSE

FALSE

TRUE

 

FALSE

TRUE

TRUE

 

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

 

TRUE

FALSE

TRUE

 

TRUE

FALSE

TRUE

 

FALSE

FALSE

TRUE

TRUE

TRUE

TRUE

 

TRUE

TRUE

FALSE

 

TRUE

TRUE

TRUE

 

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

 

TRUE

FALSE

FALSE

 

TRUE

FALSE

FALSE

 

FALSE

FALSE

FALSE

fred

joe

bill

 

TRUE

TRUE

TRUE

 

TRUE

TRUE

TRUE

 

FALSE

FALSE

FALSE

1

FALSE

FALSE

 

FALSE

FALSE

FALSE

 

TRUE

FALSE

FALSE

 

FALSE

FALSE

FALSE

FALSE

-1

FALSE

 

TRUE

FALSE

TRUE

 

TRUE

TRUE

TRUE

 

FALSE

FALSE

FALSE

FALSE

FALSE

0.001

 

TRUE

TRUE

FALSE

 

TRUE

TRUE

TRUE

 

FALSE

FALSE

FALSE

TRUE

TRUE

TRUE

 

FALSE

TRUE

FALSE

 

TRUE

TRUE

TRUE

 

FALSE

TRUE

FALSE

TRUE

joe

bill

 

fred

TRUE

FALSE

 

TRUE

TRUE

FALSE

 

FALSE

FALSE

FALSE

fred

TRUE

bill

 

FALSE

FALSE

TRUE

 

FALSE

TRUE

TRUE

 

FALSE

FALSE

FALSE

fred

joe

TRUE

 

FALSE

TRUE

TRUE

 

FALSE

TRUE

TRUE

 

FALSE

FALSE

TRUE

FALSE

joe

bill

 

FALSE

FALSE

FALSE

 

FALSE

FALSE

FALSE

 

FALSE

FALSE

FALSE

fred

FALSE

bill

 

FALSE

FALSE

TRUE

 

FALSE

FALSE

TRUE

 

FALSE

FALSE

FALSE

fred

joe

FALSE

 

TRUE

FALSE

FALSE

 

TRUE

FALSE

FALSE

 

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

 

TRUE

TRUE

TRUE

 

TRUE

TRUE

TRUE

 

FALSE

TRUE

FALSE

TRUE

0

FALSE

 

FALSE

FALSE

FALSE

 

TRUE

FALSE

FALSE

 

FALSE

FALSE

FALSE

 

 

 

 

 

 

 

 

FALSE

FALSE

FALSE

 

FALSE

FALSE

FALSE

 

 

 

 

 

 

 

 

FALSE

FALSE

FALSE

 

FALSE

FALSE

FALSE

 

Comparison of ANY ALL NONE with Excel AND/OR

Differences are highlighted in yellow.

Data

 

 

OR

AND

OR.ROWS

ANY

ALL

NONE

TRUE

TRUE

 

 

TRUE

TRUE

TRUE

TRUE

TRUE

FALSE

99

FALSE

 

 

TRUE

FALSE

TRUE

TRUE

FALSE

FALSE

-99

FALSE

 

 

TRUE

FALSE

TRUE

TRUE

FALSE

FALSE

0

FALSE

 

 

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

FALSE

 

 

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

24/09/1943

FALSE

 

 

TRUE

FALSE

TRUE

TRUE

FALSE

FALSE

1

FALSE

 

 

FALSE

FALSE

TRUE

TRUE

FALSE

FALSE

#DIV/0!

FALSE

 

 

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#N/A

FALSE

 

 

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#NAME?

FALSE

 

 

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NULL!

FALSE

 

 

#NULL!

#NULL!

#NULL!

#NULL!

#NULL!

#NULL!

#NUM!

FALSE

 

 

#NUM!

#NUM!

#NUM!

#NUM!

#NUM!

#NUM!

#REF!

FALSE

 

 

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#VALUE!

FALSE

 

 

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

 

FALSE

 

 

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

fred

TRUE

 

 

TRUE

TRUE

TRUE

TRUE

FALSE

FALSE

 

FALSE

 

 

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

 

FALSE

 

 

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

fred

joe

 

 

#VALUE!

#VALUE!

FALSE

FALSE

FALSE

TRUE

22

11

 

 

#VALUE!

#VALUE!

TRUE

TRUE

TRUE

FALSE

 

 

 

Copyright © 2023 Decision Models Ltd