https://bugs.documentfoundation.org/show_bug.cgi?id=159756
Bug ID: 159756
Summary: logical function error?
Product: LibreOffice
Version: 7.4.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: dennis.r.dyks...@gmail.com
Description:
Why does the logical function =IF(OR(J6="",K6=""),"",J6+K6) return "" when the
test is TRUE but the function =IF(OR(J6="",K6=""),J6+K6,"") return 0 when the
test is false?
Steps to Reproduce:
1.Why does the logical function =IF(OR(J6="",K6=""),"",J6+K6) return "" when
the test is TRUE but the function =IF(OR(J6="",K6=""),J6+K6,"") returns 0 when
the test is false?
2.
3.
Actual Results:
see above
Expected Results:
Following function should return "" (null) if test is false
=IF(OR(J6="",K6=""),J6+K6,"")
Reproducible: Always
User Profile Reset: No
Additional Info:
return "" instead of zero
--
You are receiving this mail because:
You are the assignee for the bug.
