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.hallot@edx.srv.br>
Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>

1 files changed, 40 insertions, 4 deletions

diff --git a/source/text/scalc/01/04060104.xhp b/source/text/scalc/01/04060104.xhp
index 9c8f52b5d3..023fca52d2 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>