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