[Libreoffice-bugs] [Bug 116324] New: Nested IF(IF( without Else path yields #VALUE!

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116324

            Bug ID: 116324
           Summary: Nested IF(IF( without Else path yields #VALUE!
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: erack at redhat.com

A1: 1
A2: 0
B3: =IF(IF(A1:A2;12);34;56)   as array formula
=>
B3: 34
B4: #VALUE!

B4 should be 56.

When giving an Else path, for example 0 or FALSE(), like in

=IF(IF(A1:A2;12;0);34;56)
=IF(IF(A1:A2;12;FALSE());34;56)

then it works correctly.

Note that a standalone =IF(A1:A2;12) array formula correctly yields {12;FALSE}

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180309/13222b8a/attachment.html>