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.

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 |