Maybe this:

B1:Y1 = sales figures

=LOOKUP(SLOPE(B1:Y1,COLUMN(B1:Y1)),{-1E100,0,0.000000000000001},{"Down","Neutral","Up"} )

--
Biff
Microsoft Excel MVP


"John Smith" wrote in message
...
im looking for a function to determine the trend of sales. i have 24
months of sales in columns b:y. All i want to do is determine if sales are
trending up or down.TREND gave a numerical value which isn't what i
wanted, maybe a true or false is sales are trending up.