Laurent,

I differentiate them by calling them array formulae, and block-array
formulae.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Laurent Longre" wrote in message
...

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