# Formula Guru...

##### New Member
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.

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

#### SteveO59L

##### Well-known Member
Where do you store your previous values ?

##### New Member
Sorry about that Steve...its still a little early.

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

#### SteveO59L

##### Well-known Member

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

##### New Member
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

##### Well-known Member

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

##### Well-known Member
bulldaddy1;2632424 I would like to know if the values in cell A1 through J1 has increased said:
When compared to what ?

##### New Member
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

##### Well-known Member
When compared to what ?

#### shg

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

=SIGN(LINEST(A1:J1))

Replies
8
Views
443
Replies
4
Views
256
Replies
3
Views
95
Replies
15
Views
365
Replies
0
Views
187

1,190,801
Messages
5,982,992
Members
439,811
Latest member
DB38

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back