On Fri, 26 Aug 2005 15:28:02 -0700, "DBane"
wrote:
I have a column of figures 20,30,40,50,60. when I select the range and put
the + at the bottom and pull, the result shows 70. the same using chart
wizard, line, right clicking add treadline. Linear, option, forcast 1
forward,the result 70 also. What formula do I have to place in the cell range
to get the return 70. I have tried trend and forcast. Totally lost.
=TREND(B3:B7,,6)
Or, if the length of your list will vary each week:
--ron
|