[Solved] Calculate difference in values between rows

[withnail]

Hi,

I have data arranged like in the attached sheet.
I want to check every row for the following:

1. Check if value in column D is 0.0040 or more points (higher) than in column C
2. Check if value in column E is 0.0040 or less points (lower) than in column C.

To be sure, I'm counting like this....0.75502 would 40 points higher than 0.75102
The 5th number in the value is not really of importance and could be rounded off if easier.

The output results can just be 0 or 1, 1 if higher or lower, 0 if not higher or lower for example.
I don't need to know/count by how much higher or lower it is, just a signal is enough.
What would be the best approach for this?
Thanks!

[FJCC]

If I understood you correctly, you can use a formula like

Code: Select all

=OR((D1-C1) >= 0.004;(E1 - C1) <= -0.004)

[withnail]

Thanks for the simple solution