sum of comparison

Glossaries

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

Term

Definition

Glossaries - Excel Terminology

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