[Solved] Calculate difference in values between rows

Discuss the spreadsheet application

[Solved] Calculate difference in values between rows

Postby withnail » Sun May 10, 2020 10:59 pm

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
(11.63 KiB) Downloaded 23 times
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

Postby FJCC » Sun May 10, 2020 11:24 pm

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
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7872
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Calculate difference in values between rows

Postby withnail » Mon May 11, 2020 12:05 pm

Thanks for the simple solution :-)
OpenOffice 4.1.7
Windows 10
withnail
 
Posts: 69
Joined: Fri Feb 15, 2019 10:57 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 27 guests