Description: Say, I used the formula =OR(ROUND(B1,2)=1,B1=""). In this case the value of cell B1 is a null string or "" returned by another formula. This results in the ROUND portion of the formula to return a #VALUE error, but the other portion to return TRUE. So, the output of the OR function should be TRUE. But instead, in this case, the error overrides the logic and the formula returns a #VALUE error. Steps to Reproduce: 1. Write a formula in a cell that returns an error. 2. Write a formula in a cell that returns TRUE. 3. Write an OR function with the input of the cell that returned an error and the cell that returned TRUE. Actual Results: #VALUE Expected Results: TRUE Reproducible: Always User Profile Reset: No Additional Info: Version: 7.2.4.1 (x64) / LibreOffice Community
Looking in the help (https://help.libreoffice.org/7.2/en-US/text/scalc/01/04060105.html?&DbPAR=WRITER&System=WIN) Logical Functions This category contains the Logical functions. Handling non-logical arguments in logical functions Zero (0) is equivalent to FALSE and all other numbers are equivalent to TRUE. Empty cells and text in cells are ignored. A #VALUE error is raised if all arguments are ignored. A #VALUE error is raised if one argument is direct text (not text in a cell). ->Errors as argument lead to an error. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ It is how it works.