From c0f70b871b7a558f5f7de355e6e18636cd90ac93 Mon Sep 17 00:00:00 2001 From: Steve Fanning Date: Sun, 31 Jan 2021 01:09:50 +0100 Subject: The syntax given in the Help file for Calc’s LOGNORM.INV function is incorrect (see Bug 137649). Specifically, the second (“Mean”) and third (“StDev”) arguments are optional rather than required in Calc’s current implementation. If omitted the Mean argument defaults to 0.0 and the StDev argument defaults to 1.0. MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Note: The corresponding Excel function’s three arguments are all required (none are optional) and so one possible outcome of Bug 137649 is for Calc to be updated to match this behaviour for interoperability. However, we do not know if or when this might happen and so, in the meantime, I propose to update the Help to more accurately reflect Calc’s current behaviour. The change affects only one file, 04060183.xhp. Change-Id: I69934a8123d5de41007bc4dfca1cbc478ed963a6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110150 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/scalc/01/04060183.xhp | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'source/text/scalc/01/04060183.xhp') diff --git a/source/text/scalc/01/04060183.xhp b/source/text/scalc/01/04060183.xhp index cc5039eefc..b4eb4c6f25 100644 --- a/source/text/scalc/01/04060183.xhp +++ b/source/text/scalc/01/04060183.xhp @@ -225,11 +225,11 @@ LOGINV(Number [; Mean [; StDev]]) -Number is the probability value for which the inverse standard logarithmic distribution is to be calculated. +Number (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated. -Mean is the arithmetic mean of the standard logarithmic distribution. +Mean (optional) is the arithmetic mean of the standard logarithmic distribution (defaults to 0 if omitted). -StDev is the standard deviation of the standard logarithmic distribution. +StDev (optional) is the standard deviation of the standard logarithmic distribution (defaults to 1 if omitted). =LOGINV(0.05;0;1) returns 0.1930408167. @@ -244,13 +244,13 @@ This function is identical to LOGINV and was introduced for interoperability with other office suites. -LOGNORM.INV(Number; Mean; StDev) +LOGNORM.INV(Number [; Mean [; StDev]]) Number (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated. -Mean (required) is the arithmetic mean of the standard logarithmic distribution. +Mean (optional) is the arithmetic mean of the standard logarithmic distribution (defaults to 0 if omitted). -StDev (required) is the standard deviation of the standard logarithmic distribution. +StDev (optional) is the standard deviation of the standard logarithmic distribution (defaults to 1 if omitted). =LOGNORM.INV(0.05;0;1) returns 0.1930408167. -- cgit