| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TREND help | Excel Worksheet Functions | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
| Using Trend | Excel Discussion (Misc queries) | |||
| trend | Excel Discussion (Misc queries) | |||
Linear Mode
