source/text/scalc/01/04060104.xhp | 44 ++++++++++++++++++++++++++++++++++----
1 file changed, 40 insertions(+), 4 deletions(-)
New commits:
commit 8322ff882f06c6c92e4c9d9e4bf762e06a5a754c
Author: Olivier Hallot <olivier.hal...@edx.srv.br>
Date: Thu Apr 23 21:51:23 2015 -0300
tdf#64773 Help pages for IFNA and IFERROR functions
Help entries for IFNA and IFERROR Calc functions
Change-Id: I19c03ef50af17dc70fe45c36e4589c1f267800f9
Reviewed-on: https://gerrit.libreoffice.org/15503
Reviewed-by: Olivier Hallot <olivier.hal...@edx.srv.br>
Tested-by: Olivier Hallot <olivier.hal...@edx.srv.br>
diff --git a/source/text/scalc/01/04060104.xhp
b/source/text/scalc/01/04060104.xhp
index 9c8f52b..023fca5 100644
--- a/source/text/scalc/01/04060104.xhp
+++ b/source/text/scalc/01/04060104.xhp
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
+
<!--
* This file is part of the LibreOffice project.
*
@@ -18,8 +18,8 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-
+
+
<meta>
<topic id="textscalc0104060104xml" indexer="include">
<title id="tit" xml-lang="en-US">Information Functions</title>
@@ -32,7 +32,7 @@
<bookmark_value>functions; information functions</bookmark_value>
</bookmark>
<paragraph role="heading" id="hd_id3147247" xml-lang="en-US" level="1"
l10n="U" oldref="1">Information Functions</paragraph>
-<paragraph role="paragraph" id="par_id3147499" xml-lang="en-US" l10n="CHG"
oldref="2"><variable id="informationtext">This category contains the
<emph>Information</emph> functions.
+<paragraph role="paragraph" id="par_id3147499" xml-lang="en-US" l10n="CHG"
oldref="2"><variable id="informationtext">This category contains the
<emph>Information</emph> functions.
</variable></paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000404.xhp#eikain"/>
@@ -354,6 +354,25 @@
<paragraph role="paragraph" id="par_id1889095" xml-lang="en-US" l10n="NEW">
<item type="input">=ISERROR(C9)</item> where cell C9 contains <item
type="input">=NA()</item> returns TRUE.</paragraph>
</section>
+<section id="iferror">
+<bookmark xml-lang="en-US" branch="index"
id="bm_id31470811"><bookmark_value>IFERROR function</bookmark_value>
+<bookmark_value>testing;general errors</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_IFERROR" id="bm_id31452061"
localize="false"/>
+<paragraph role="heading" id="hd_id31470811" xml-lang="en-US" level="2"
l10n="U" oldref="53">IFERROR</paragraph>
+<paragraph role="paragraph" id="par_id31563161" xml-lang="en-US" l10n="CHG"
oldref="54"><ahelp hid="HID_FUNC_IFERROR">Returns the value if the cell does
not contains an error value, or the alternative value if it
does.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id31475691" xml-lang="en-US" level="3"
l10n="U" oldref="55">Syntax</paragraph>
+<paragraph role="code" id="par_id31531551" xml-lang="en-US" l10n="U"
oldref="56">IFERROR(Value;Alternate_value)</paragraph>
+<paragraph role="paragraph" id="par_id31540471" xml-lang="en-US" l10n="CHG"
oldref="57">
+<emph>Value</emph> is the value or expression to be be returned if it does not
equal or result in an error.</paragraph>
+<paragraph role="paragraph" id="par_id31540472" xml-lang="en-US" l10n="CHG"
oldref="57">
+<emph>Alternate_value</emph> is the value or expression to be be returned if
the expression or value of <emph>Value</emph> does equal or result in an
error.</paragraph>
+<paragraph role="heading" id="hd_id31559941" xml-lang="en-US" level="3"
l10n="U" oldref="58">Example</paragraph>
+<paragraph role="paragraph" id="par_id31502561" xml-lang="en-US" l10n="CHG"
oldref="59">
+<item type="input">=IFERROR(C8;C9)</item> where cell C8 contains <item
type="input">=1/0</item> returns the value of C9, because 1/0 is an
error.</paragraph>
+<paragraph role="paragraph" id="par_id18890951" xml-lang="en-US" l10n="NEW">
+<item type="input">=IFERROR(C8;C9)</item> where cell C8 contains <item
type="input">13</item> returns 13, the value of C8, which is not an
error.</paragraph>
+</section>
<section id="isformula">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153618"><bookmark_value>ISFORMULA function</bookmark_value>
<bookmark_value>recognizing formula cells</bookmark_value>
@@ -480,6 +499,23 @@
<paragraph role="paragraph" id="par_id3154852" xml-lang="en-US" l10n="U"
oldref="99">
<item type="input">=ISNA(D3)</item> returns FALSE as a result.</paragraph>
</section>
+<section id="ifna">
+<bookmark xml-lang="en-US" branch="index"
id="bm_id31536851"><bookmark_value>IFNA function</bookmark_value>
+<bookmark_value>#N/A error;testing</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_IFNA" id="bm_id3159273"
localize="false"/>
+<paragraph role="heading" id="hd_id31536851" xml-lang="en-US" level="2"
l10n="U" oldref="93">IFNA</paragraph>
+<paragraph role="paragraph" id="par_id31491051" xml-lang="en-US" l10n="U"
oldref="94"><ahelp hid="HID_FUNC_IFNA">Returns the value if the cell does not
contains the #N/A (value not available) error value, or the alternative value
if it does.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id31529471" xml-lang="en-US" level="3"
l10n="U" oldref="95">Syntax</paragraph>
+<paragraph role="code" id="par_id31537481" xml-lang="en-US" l10n="U"
oldref="96">IFNA(Value;Alternate_value)</paragraph>
+<paragraph role="paragraph" id="par_id31528841" xml-lang="en-US" l10n="U"
oldref="97">
+<emph>Value</emph> is the value or expression to be be returned if it does not
equal or result in an #N/A error.</paragraph>
+<paragraph role="paragraph" id="par_id31528842" xml-lang="en-US" l10n="U"
oldref="97">
+<emph>Alternate_value</emph> is the value or expression to be be returned if
the expression or value of <emph>Value</emph> does equal or result in an #N/A
error.</paragraph>
+<paragraph role="heading" id="hd_id31499641" xml-lang="en-US" level="3"
l10n="U" oldref="98">Example</paragraph>
+<paragraph role="paragraph" id="par_id31548521" xml-lang="en-US" l10n="U"
oldref="99">
+<item type="input">=IFNA(D3;D4)</item> returns the value of D3 if D3 does not
result in an #N/A error, or D4 if it does.</paragraph>
+</section>
<section id="istext">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3149426"><bookmark_value>ISTEXT function</bookmark_value>
<bookmark_value>cell contents;text</bookmark_value>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
