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

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

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 ?

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

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 ?