Excel will not displaying the results of a trend array formula
Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.
Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.
The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.
Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'
However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)
If this doesn't make sense, let me know.
Sep 30, 2008 |
Microsoft Excel for PC