I think that I am making this more complicated than this is but here it
goes. At work we were given 3 years of enrollment data. I know that the
more data we have the better we are but all we were given at work is 3
years of data to work with! Our task is to make a prediction on the 4th
year of data. What I need is a positive or negative ex. 16 or -16. I an
using =FORECAST(2007,B2:D2,$B$1:$D$1) this equals 22.66666667. I also
tried =TREND(B2:D2,$B$1:$D$1,2007) which gave me 22.66666667. This
tells me 22.66666667 but it does not give me a minus number. IAnother
approach I took was =(C2-B2)+(D2-C2) this gives me a -16. Thisis the
type value that I am looking for. To find the range I used
=MAX(B2:D2)-MIN(B2:D2) and to see if the data was trending up down or
stable (Harlan's formula)
=CHOOSE(2+SIGN(INDEX(LINEST(B2:D2),1)),"Down","Sta ble","Up"). My
question is what is the right approch to get the plus or minus figure?
If I use trend or forcast it does not tell me +Number or -number. Is
using =(C2-B2)+(D2-C2) this gives me a -16 is this the right approach?
Can someone please guide me! Thanks in advance.

2004 2005 2006
48 36 32