product of comparison

Glossaries

Term	Definition
product of comparison	Glossaries - Excel Terminology The term "Product of Comparison" is used on this site to describe the substitution of an expression that multiplies the results of two or more comparison operations to apply a logical AND to a set of values. Since the AND function cannot be used in an array expression, except where all conditions are to be evaluated at once, the use of a product of two or more comparisons enables evaluation cell-by-cell of logical AND conditions thus: (A1:A10>10)*(B1:B10<10)>0 will return TRUE for each of the ten rows only if both conditions are met.

Term

Definition

Glossaries - Excel Terminology

The term "Product of Comparison" is used on this site to describe the substitution of an expression that multiplies the results of two or more comparison operations to apply a logical AND to a set of values. Since the AND function cannot be used in an array expression, except where all conditions are to be evaluated at once, the use of a product of two or more comparisons enables evaluation cell-by-cell of logical AND conditions thus: (A1:A10>10)*(B1:B10<10)>0 will return TRUE for each of the ten rows only if both conditions are met.