TREND WORKSHEET FUNCTION

[F. Lawrence Kulchar]

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

 

[Halim]

Hi,

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

in every C1:C3 cell

 

[Bob Phillips]

Select cells c1:c3 and enter the formula in the formula bar, then
Ctrl-Shift-Enter


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[F. Lawrence Kulchar]

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

 

[Bob Phillips]

check my response

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)