Help with trend formula

[ljf101]

Can anybody help,

I'm trying to show a trend or a forecast but I'm doing something wrong because I keep getting #Value as a result. Can I adjust a forecast to show a 25% drop in figures over a period of month.

I would be eternally Grateful ray:

actual (version 1).xls
	A	B	C	D	E	F	G	H	I	J
2		Cost/RevenueElements	Month8	Month9	Month10	Month11	Month12	Month13	Month14	Month15
3	relief	***57799TotalServiceLineExpense	454,589.37	364,721.53	379,434.32	431,460.78	400,553.52	#VALUE!
4	expen	***57999TotalComputerRelated	304,757.55-	206,708.59-	270,758.96-	277,508.18-	269,607.96-	#VALUE!
5	expen	***59699TotalAdministrative	3,348.16-	3,347.91-	3,347.90-	6,484.16-	3,347.91-	#VALUE!
6	Expense		308,105.71-	210,056.50-	274,106.86-	283,992.34-	272,955.87-	#VALUE!
7	Contribution	*******75999UnitContribution	151,793.02	152,378.22	105,327.46	147,468.44	127,597.65
Sheet1

 

[Brian from Maui]

I'm not sure but the range C2:G2 must be numeric

 

[fairwinds]

Would not just
=TREND(C3:G3)
suffice?

 

[ljf101]

I dont think it will it would need a '+known X'

Would not just
=TREND(C3:G3)
suffice?

 

[ljf101]

I have changed the 'x' to a numeric value and still I get #Value

 

[fairwinds]

Take away the ref to H:J columns.

 

[Brian from Maui]

I have changed the 'x' to a numeric value and still I get #Value

Need to change H2:J2 also

 

[ljf101]

I have changed all of the month field to numeric

Also I have tried the formula without showing H:J but to no avail
=TREND(C3:G3,C2:G2,)

 

[fairwinds]

=TREND(C3:G3,C2:G2)

delete last comma.

 

[Brian from Maui]

An abbreviated sample,

Book1
	A	B	C	D	E	F	G	H	I
1	8	9	10	11	12	13	14	15	16
2	454589	364721	379434	431460	400553	556328.1
Sheet1

going to bed now!