Is there a way to check for sign change?

[JaydenK]

Hello all,

Is there a way to check for sign change in the workbook and take the corresponding value before the change? For example, let's say I have 4 columns. I want to check for a sign change in column 2 and take the corresponding value so when column 2 changes from - to +, I take that last number. Then the second time around, I take the next corresponding value and subtract the first one. In this example, the first value I'd get is 0.6, then second value 1-.6 = .4.

Any help would be greatly appreciated.