I call them "single-cell array formula" and "multi-cell array
formula", respectively.


On Oct 23, 12:38 am, Laurent Longre wrote:
Hello,

There are two kinds of array formulas in Excel :

- Formulas returning a scalar and entered in a single cell :
{=MAX(C1:C50/D1:D50)} array entered in A1

- Formulas returning an array and entered in a range of cells :
{=TREND(C1:C50,D1:D50)} array entered in A1:A50

How would you name each kind of array formula in a good English : single-cell
array formula vs multiple-cells array formula...?

How would you define the range A1:A50 : matrix range ?

Thanks !

Laurent