=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:[email protected] From:60;Hylton Conacher (ZR1HPC)[email protected] Subject:;[libreoffice-users] LO 6.4.6.2 CALC : Appropriate formula? To:;=LibreOffice [email protected] 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: [email protected] 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
