Many thanks for your replies.

"Single-result" and "multiple-result" seem to be fine.

Laurent

JE McGimpsey a écrit :
I tend to use the language in XL Help which focuses on the nature of the
results, not where the results are entered, since you can array-enter
=MAX(C1:C50/D1:D50 in multiple cells (you just get the same result in
each cell). Likewise, one can array-enter =LINEST(D1:D50,C1:C50) in a
single cell, which discards all but one of the returned values. So:

1) Array formula with a single result, or single-result array formula
2) Array formula with multiple results, or multiple-result array formula

The range A1:A50 is, to me, the result range. I reserve "matrix" for
MMULT, MINVERSE, etc.

Just my US$0.02

In article ,
Laurent Longre wrote:

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 ?