Fix fdo#80432. Help entries for NORM functions

Write help pages for LOGNORM.DIST, LOGNORM.INV, NORM.DIST, NORM.INV, NORM.S.DIST and NORM.S.INV spreadsheet functions

Change-Id: I00f92dd339c6485f2f7b809f2e441241cde5a9d7
Reviewed-on: https://gerrit.libreoffice.org/9925
Reviewed-by: Caolán McNamara <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>

1 files changed, 42 insertions, 1 deletions

diff --git a/source/text/scalc/01/04060183.xhp b/source/text/scalc/01/04060183.xhp
index 3dc2ffdeb5..0e617b9019 100644
--- a/source/text/scalc/01/04060183.xhp
+++ b/source/text/scalc/01/04060183.xhp
@@ -164,7 +164,27 @@
 <emph>StDev</emph> is the standard deviation of the standard logarithmic distribution.</paragraph>
 <paragraph role="heading" id="hd_id3148768" xml-lang="en-US" level="3" l10n="U" oldref="73">Example</paragraph>
 <paragraph role="paragraph" id="par_id3155623" xml-lang="en-US" l10n="U" oldref="74">
-<item type="input">=LOGINV(0.05;0;1)</item> returns 0.19.</paragraph>
+<item type="input">=LOGINV(0.05;0;1)</item> returns 0.1930408167.</paragraph>
+</section>
+<section id="lognormdotinv">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2901928"><bookmark_value>LOGNORM.INV function</bookmark_value>
+<bookmark_value>inverse of lognormal distribution</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGINV_MS" id="bm_id2901062" localize="false"/>
+<paragraph role="heading" id="hd_id2901928" xml-lang="en-US" level="2" l10n="U" oldref="66">LOGNORM.INV</paragraph>
+<paragraph role="paragraph" id="par_id2901297" xml-lang="en-US" l10n="U" oldref="67"><ahelp hid="HID_FUNC_LOGINV_MS">Returns the inverse of the lognormal distribution.</ahelp></paragraph>
+<paragraph id="par_id290122405814" role="paragraph" xml-lang="en-US">This function is identical to LOGINV and was introduced for interoperability with other office suites.</paragraph>
+<paragraph role="heading" id="hd_id2901016" xml-lang="en-US" level="3" l10n="U" oldref="68">Syntax</paragraph>
+<paragraph role="code" id="par_id2901049" xml-lang="en-US" l10n="U" oldref="69">LOGNORM.INV(Number; Mean; StDev)</paragraph>
+<paragraph role="paragraph" id="par_id2901390" xml-lang="en-US" l10n="U" oldref="70">
+<emph>Number</emph> (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated.</paragraph>
+<paragraph role="paragraph" id="par_id2901538" xml-lang="en-US" l10n="U" oldref="71">
+<emph>Mean</emph> (required) is the arithmetic mean of the standard logarithmic distribution.</paragraph>
+<paragraph role="paragraph" id="par_id2901355" xml-lang="en-US" l10n="U" oldref="72">
+<emph>StDev</emph> (required) is the standard deviation of the standard logarithmic distribution.</paragraph>
+<paragraph role="heading" id="hd_id2901768" xml-lang="en-US" level="3" l10n="U" oldref="73">Example</paragraph>
+<paragraph role="paragraph" id="par_id2901623" xml-lang="en-US" l10n="U" oldref="74">
+<item type="input">=LOGNORM.INV(0.05;0;1)</item> returns 0.1930408167.</paragraph>
 </section>
 <section id="lognormdist">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3158417"><bookmark_value>LOGNORMDIST function</bookmark_value>
@@ -187,6 +207,27 @@
 <paragraph role="paragraph" id="par_id3149778" xml-lang="en-US" l10n="U" oldref="84">
 <item type="input">=LOGNORMDIST(0.1;0;1)</item> returns 0.01.</paragraph>
 </section>
+<section id="lognormdotdist">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2901417"><bookmark_value>LOGNORM.DIST function</bookmark_value>
+<bookmark_value>lognormal distribution</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMDIST_MS" id="bm_id2901366" localize="false"/>
+<paragraph role="heading" id="hd_id2908417" xml-lang="en-US" level="2" l10n="U" oldref="76">LOGNORM.DIST</paragraph>
+<paragraph role="paragraph" id="par_id2904953" xml-lang="en-US" l10n="U" oldref="77"><ahelp hid="HID_FUNC_NORMDIST_MS">Returns the values of a lognormal distribution.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id2900474" xml-lang="en-US" level="3" l10n="U" oldref="78">Syntax</paragraph>
+<paragraph role="code" id="par_id2900686" xml-lang="en-US" l10n="U" oldref="79">LOGNORM.DIST(Number; Mean; StDev; Cumulative)</paragraph>
+<paragraph role="paragraph" id="par_id2904871" xml-lang="en-US" l10n="U" oldref="80">
+<emph>Number</emph> (required) is the probability value for which the standard logarithmic distribution is to be calculated.</paragraph>
+<paragraph role="paragraph" id="par_id2905820" xml-lang="en-US" l10n="U" oldref="81">
+<emph>Mean</emph> (required) is the mean value of the standard logarithmic distribution.</paragraph>
+<paragraph role="paragraph" id="par_id2905991" xml-lang="en-US" l10n="U" oldref="82">
+<emph>StDev</emph> (required) is the standard deviation of the standard logarithmic distribution.</paragraph>
+<paragraph role="paragraph" id="par_id2905992" xml-lang="en-US" l10n="NEW">
+<emph>Cumulative</emph> (required) = 0 calculates the density function, Cumulative = 1 calculates the distribution.</paragraph>
+<paragraph role="heading" id="hd_id2903178" xml-lang="en-US" level="3" l10n="U" oldref="83">Example</paragraph>
+<paragraph role="paragraph" id="par_id2909778" xml-lang="en-US" l10n="U" oldref="84">
+<item type="input">=LOGNORM.DIST(0.1;0;1;1)</item> returns 0.0106510993.</paragraph>
+</section>
 </sort>
 <section id="relatedtopics">
 <embed href="text/scalc/01/04060100.xhp#drking"/>