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

            Bug ID: 99613
           Summary: optional Paramaters for IF is optional
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Documentation
          Assignee: [email protected]
          Reporter: [email protected]
            Blocks: 80430

"In the LibreOffice Calc functions, parameters marked as "optional" can be left
out only when no parameter follows. For example, in a function with four
parameters, where the last two parameters are marked as "optional", you can
leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter
3 alone."
Quoted from IF function at
https://help.libreoffice.org/Calc/Logical_Functions#IF
http://vm173.documentfoundation.org/text/scalc/01/04060105.xhp

This is simply untrue in the case of IF, try it yourself with:
=IF("a"="b";;)

(If that makes sense is totally different, but it works, same useful as
=FALSE())

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

Reply via email to