https://bugs.documentfoundation.org/show_bug.cgi?id=101465
Bug ID: 101465
Summary: If statement Function Wizard Result not the same as
cell
Product: LibreOffice
Version: 5.1.4.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: lan...@yahoo.com
Two identical calc spreadsheets. Each has the same formula. A1 is some result
between 0 and 100. A2 is the lower limit, let's say 25. A3 is the upper
limit, let's say 75.
The intent of the formula is that if the value falls at or between the limits
of 25-75 then it will print the number, otherwise an out of limits warning
message.
Note: it appears all three variants of "TRUE" work: =1 or =TRUE or =TRUE() all
seem to work.
=IF(AND(A1>=A2,A1<=A3)=1,A1,"Out of limits")
=IF(AND(A1>=A2,A1<=A3)=TRUE,A1,"Out of limits")
=IF(AND(A1>=A2,A1<=A3)=TRUE(),A1,"Out of limits")
One spreadsheet prints the number value in cell A1, the other spreadsheet will
not. The other spreadsheet only prints TRUE or FALSE.
It should be noted that the Function Wizard Results show the number only in
both spreadsheets.
Why does the second spreadsheet cell say TRUE or FALSE only?
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
