I need a formula that will return a value of "positive", "negative" or "no trend" from a series of numbers eg. Have tried nested if statements and TREND() but none of thses return the correct result
10 20 30 40 = Positive or
10 09 08 07 = Negative or
10 12 08 15 = No trend.
Any suggestions?
David
10 20 30 40 = Positive or
10 09 08 07 = Negative or
10 12 08 15 = No trend.
Any suggestions?
David