Conditional array calculations

A conditional array calculation is an array or matrix formula that includes an IF() function.

The condition argument in the formula is an area reference or a matrix result.

In the following example, the >0 test of the {=IF(A1:A3>0,"yes","no")} formula is applied to each cell in the range A1:A3 and the result is copied to the corresponding cell.

Table 1. Example of a conditional array calculation
  A B (formula) B (result)
1 1 {=IF(A1:A3>0,"yes","no")} yes
2 0 {=IF(A1:A3>0,"yes","no")} no
3 1 {=IF(A1:A3>0,"yes","no")} yes

Trademarks | IBM Connections wiki