Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trend Function | Excel Worksheet Functions | |||
constraints for the trend function | Excel Discussion (Misc queries) | |||
constraints for the trend function | Excel Discussion (Misc queries) | |||
Help with TREND function | Excel Worksheet Functions | |||
Trend function in VB | Excel Programming |