Hi guys,
I have a list of data in column A which updates automatically with new values being inserted in the next row in the column.
Is there a formula that will return the word "stable" when the last 10 values are within 0.03 of each other?
For example, the last 10 values may fluctuate between 2.50 and 2.52 and it is in situations like these that I would like the formula to fire.
Thanks
I have a list of data in column A which updates automatically with new values being inserted in the next row in the column.
Is there a formula that will return the word "stable" when the last 10 values are within 0.03 of each other?
For example, the last 10 values may fluctuate between 2.50 and 2.52 and it is in situations like these that I would like the formula to fire.
Thanks