[Solved] Calculate difference in values between rows

[Solved] Calculate difference in values between rows

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!
Attachments
example.ods
Last edited by withnail on Mon May 11, 2020 12:06 pm, edited 1 time in total.
OpenOffice 4.1.7
Windows 10
withnail

Posts: 69
Joined: Fri Feb 15, 2019 10:57 pm

Re: Calculate difference in values between rows

If I understood you correctly, you can use a formula like
Code: Select all   Expand viewCollapse view
`=OR((D1-C1) >= 0.004;(E1 - C1) <= -0.004)`
Windows 10 and Linux Mint, since 2017
FJCC
Moderator

Posts: 7872
Joined: Sat Nov 08, 2008 8:08 pm

Re: Calculate difference in values between rows

Thanks for the simple solution
OpenOffice 4.1.7
Windows 10
withnail

Posts: 69
Joined: Fri Feb 15, 2019 10:57 pm

Who is online

Users browsing this forum: No registered users and 27 guests