source/text/scalc/01/04060105.xhp | 7 +++++--
1 file changed, 5 insertions(+), 2 deletions(-)
New commits:
commit 9d505510f15289b1393c2b2c654b23f03790c250
Author: Seth Chaiklin <sdc.bla...@youmail.dk>
AuthorDate: Tue Dec 8 14:36:24 2020 +0100
Commit: Eike Rathke <er...@redhat.com>
CommitDate: Thu Dec 17 15:40:26 2020 +0100
tdf#99613 clarify empty parameters in IF function in Calc
+ add two examples; explain that empty parameters are
considered to be 0.
Change-Id: I5c218472774fdd00581cc0e12f2b228191742275
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/107381
Tested-by: Jenkins
Reviewed-by: Eike Rathke <er...@redhat.com>
diff --git a/source/text/scalc/01/04060105.xhp
b/source/text/scalc/01/04060105.xhp
index 3dbcab1a4..d42ad8e03 100644
--- a/source/text/scalc/01/04060105.xhp
+++ b/source/text/scalc/01/04060105.xhp
@@ -108,7 +108,7 @@
<h2 id="hd_id3150141">IF</h2>
<paragraph xml-lang="en-US" id="par_id3148740"
role="paragraph"><ahelp hid="HID_FUNC_WENN">Specifies a logical test to be
performed.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3154558" role="code">IF(Test [;
ThenValue [; OtherwiseValue]])</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3154558" role="code">IF(Test [;
[ThenValue] [; [OtherwiseValue]]])</paragraph>
<paragraph xml-lang="en-US" id="par_id3149727" role="paragraph">
<emph>Test</emph> is any value or expression that can be TRUE or
FALSE.</paragraph>
<paragraph xml-lang="en-US" id="par_id3155828" role="paragraph">
@@ -120,7 +120,10 @@
</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3150867" role="paragraph">
- <item type="input">=IF(A1>5;100;"too small")</item> If the
value in A1 is higher than 5, the value 100 is entered in the current cell;
otherwise, the text “too small” (without quotes) is entered.</paragraph>
+ <input>=IF(A1>5;100;"too small")</input> If the value in
<literal>A1</literal> is greater than <literal>5</literal>, the value
<literal>100</literal> is returned; otherwise, the text <literal>too
small</literal> is returned.</paragraph>
+ <paragraph role="paragraph" id="par_id71607569817532">
+ <input>=IF(A1>5;;"too small")</input> If the value in
<literal>A1</literal> is greater than <literal>5</literal>, the value
<literal>0</literal> is returned because empty parameters are considered to be
<literal>0</literal>; otherwise, the text <literal>too small</literal> is
returned.</paragraph>
+ <paragraph role="paragraph"
id="par_id11607570458867"><input>=IF(A1>5;100;)</input> If the value in
<literal>A1</literal> is less than <literal>5</literal>, the value
<literal>0</literal> is returned because the empty <emph>OtherwiseValue</emph>
is interpreted as <literal>0</literal>; otherwise <literal>100</literal> is
returned.</paragraph>
</section>
<section id="Section3">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3155954"><bookmark_value>NOT function</bookmark_value>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
