Multiple Condition Formula
cgb45
Posted messages
1
Status
Member
-
Raymond PENTIER Posted messages 58219 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58219 Registration date Status Contributor Last intervention -
Hello,
I am looking to create a multi-condition formula in LibreOffice Calc.
My table has 3 columns corresponding to the validation dates of an official document and the expected result:
- a theoretical validation date (column A)
- an actual validation date (column B)
- the status of the document based on these dates (column C).
If date B is less than (or earlier than) date A, column C should indicate "Validated".
If date B is not filled in, column C should indicate "In the process of validation".
If date A is less than (earlier than) or equal to TODAY, column C should indicate "Validated by default of response".
All my attempts result in partial or incorrect results.
Thank you in advance for your help!
I am looking to create a multi-condition formula in LibreOffice Calc.
My table has 3 columns corresponding to the validation dates of an official document and the expected result:
- a theoretical validation date (column A)
- an actual validation date (column B)
- the status of the document based on these dates (column C).
If date B is less than (or earlier than) date A, column C should indicate "Validated".
If date B is not filled in, column C should indicate "In the process of validation".
If date A is less than (earlier than) or equal to TODAY, column C should indicate "Validated by default of response".
All my attempts result in partial or incorrect results.
Thank you in advance for your help!
