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

            Bug ID: 89166
           Summary: IF statement in cell does not work as expected.
           Product: LibreOffice
           Version: 4.3.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
          Assignee: [email protected]
          Reporter: [email protected]

According to calcguide this should work;
=IF(C3>0, B3/C3, "No Report")

it does not work, ; is expected instead of commas.
More important . if true-calculation does not work

=IF(3=3; B3/C3)  gives "TRUE"
=IF(3=3; "10") works as text
=IF(3=3; 3) does not work

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to