Formula Guru...

[bulldaddy1]

I need some help from a formula Guru PLEASE...

I have a "row" of 10 numbers and I want to know if the value in this row of numbers has increased, decreased or stayed constant over a period of time.

Thank you for your expertise!

 

[SteveO59L]

Where do you store your previous values ?

 

[bulldaddy1]

Sorry about that Steve...its still a little early.

I have "one" number in each row...I have a total of 10 rows.

 

[SteveO59L]

Your explanation is unclear.

Try posting a sample of your data, and what you would like to do with it.

 

[bulldaddy1]

A1 B2 C1 D1 E1 F1 G1 H1 I1 J1
1.99 1.99 2.09 2.09 2.09 2.19 2.19 2.29 2.29 2.34

I would like to know if the values in cell A1 through J1 has increased, decreased or stay constant.

Thanks for your patience with me!

 

[BGY23]

Hi Buildaddy,

In orderto tell if a number has changed or remained constant you have to compare it to another number. Assuming the numbers in A1 to J1 are formula driven you must maintain somewhere a fixed copy of the numbers at a point in time. Then when you want to see if the trend has changed you compare the numbers in a1 to j1 to the fixed point.

i don't believe excel can tell you if a number is constant or changing since the last time you opened the file? Though I could be wrong.

 

[SteveO59L]

When compared to what ?

 

[bulldaddy1]

I think I am asking for the impossible...

But, I am trying to determine if the values in "ROW" 1 have increased, decreased or stayed constant starting with cell A1 and ending with cell J1.

 

[SteveO59L]

When compared to what ?

 

[shg]

This returns 1 if the trend of the series is increasing, -1 if decreasing, 0 if flat.

=SIGN(LINEST(A1:J1))