Re: [libreoffice-users] LO 6.4.6.2 CALC : Appropriate formula?

=If I understand your issue?? Don't know if this will come thru OK.
Put these vaues in row 1 and formula in A2 and B2.
Change Date to my format. Changed values in D1,A1, and G1, and got 
the matching date when it was larger.


25
07/01/20
60
05/09/20
30
07/26/20
60
05/09/20


A2: =IF(AND(A1D1,A1G1),A1,IF(AND(D1A1,D1=G1),D1,G1))
B2: =IF(AND(A1D1,A1G1),B1,IF(AND(D1A1,D1=G1),E1,H1))


A2: =IF(AND(A1D1,A1G1),A1,IF(AND(D1A1,D1G1),D1,G1))
B2: =IF(AND(A1D1,A1G1),B1,IF(AND(D1A1,D1G1),E1,H1))




On 15 Sep 2020 at 13:50, Hylton Conacher (ZR1HPC) wrote:

Send reply to:hylton@conacher.co.za
From:60;Hylton Conacher (ZR1HPC)hylton@conacher.co.za
Subject:;[libreoffice-users] LO 6.4.6.2 CALC : Appropriate 
formula?
To:;=LibreOffice Usersusers@global.libreoffice.orgDate sent:60;Tue, 15 Sep 2020 13:50:38 +0200


HI,


USING


I have eight data values on a single row with corresponding dates next
to each value in the format below i.e.


AB C&#
-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy