Array & Trend
 

How do I set up the trend function for the following?

A B C D
1 2008 2007 2006 2005
2 ??? 12 10 9

where the ??? is what I want the trend to be.
--
Gator

Array & Trend
 

I believe this will do it:
=TREND(C3:E3,C2:E2,B2)

I would recommend arranging your data from smallest to largest; this seems
more intuitive.



Regards,
Ryan---


--
RyGuy


"Gator" wrote:

How do I set up the trend function for the following?

A B C D
1 2008 2007 2006 2005
2 ??? 12 10 9

where the ??? is what I want the trend to be.
--
Gator

Array & Trend
 

=TREND(B2:D2,B1:D1,A1)

--


Regards,


Peo Sjoblom


"Gator" wrote in message
...
How do I set up the trend function for the following?

A B C D
1 2008 2007 2006 2005
2 ??? 12 10 9

where the ??? is what I want the trend to be.
--
Gator