I did all of that...and I got the SAME 3 values.....22196;

I do NOT YET understand where (or how) the 3 values come from??

Please advise.

FLKulchar

"Halim" wrote:

Hi,

Make sure you're using absolute range address like :
=TREND($B$1:$B$3,$A$1:$A$3)

in every C1:C3 cell
--

Regards,

Halim


"F. Lawrence Kulchar" wrote:

The following data is imputted:

A B

1 20234
2 21003
3 10000


Some worksheet functions return arrays of values, or require an array of
values as an argument. To calculate multiple results with an array formula,
you must enter the array into a range of cells that has the same number of
rows and columns as the array arguments have.

Select the range of cells in which you want to enter the array formula.
Type the array formula.
For example, given a series of three sales figures (column B) for a series
of three months (column A), the TREND function determines the straight-line
values for the sales figures. To display all of the results of the formula,
it is entered into three cells in column C (C1:C3).



Array formula that produces multiple results

When you enter the formula =TREND(B1:B3,A1:A3) as an array formula, it
produces three separate results (22196, 17079, and 11962), based on the three
sales figures and the three months.

Press CTRL+SHIFT+ENTER.

QUESTION: PLEASE EXPLAIN WHERE THE 17079 and 11962 come from in the above
example.

I do NOT understandm the 3 separate results??

Thanks,

FLKulchar