Array vocabulary

[Laurent Longre]

Hello,

There are two kinds of array formulas in Excel :

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

- Formulas returning an array and entered in a range of cells :
{=TREND(C1:C50,D150)} 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

 

[Bob Phillips]

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)

 

[JE McGimpsey]

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/D150 in multiple cells (you just get the same result in
each cell). Likewise, one can array-enter =LINEST(D150,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

 

[ilia]

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

 

[Laurent Longre]

Many thanks for your replies.

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

Laurent

JE McGimpsey a écrit :