From a7337c9922374b225595776e7b5ab9f87c9e2856 Mon Sep 17 00:00:00 2001 From: Steve Fanning Date: Mon, 1 Jun 2020 11:47:38 +0200 Subject: (04060185.xhp) Include square brackets in syntax sections to indicate optional parameters. Change-Id: I8d099d9babe118c7592b060027dd037e9fbdadaf Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95245 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 79dfc48af63b0834aee096c65f92f1bc96fc1b6c) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95736 Reviewed-by: Ilmari Lauhakangas --- source/text/scalc/01/04060185.xhp | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp index 1243793dd3..65bfaec408 100644 --- a/source/text/scalc/01/04060185.xhp +++ b/source/text/scalc/01/04060185.xhp @@ -38,7 +38,7 @@

RANK

Returns the rank of a number in a sample. - RANK(Value; Data; Type) + RANK(Value; Data [; Type]) Value is the value, whose rank is to be determined. @@ -62,7 +62,7 @@ The difference between RANK.AVG and RANK.EQ occurs when there are duplicates in the list of values. The RANK.EQ function returns the lower rank, whereas the RANK.AVG function returns the average rank. -RANK.AVG(Value; Data; Type) +RANK.AVG(Value; Data [; Type]) Value is the value, whose rank is to be determined. Data is the array or range of data in the sample. Type (optional) is the sequence order. @@ -82,7 +82,7 @@ The difference between RANK.AVG and RANK.EQ occurs when there are duplicates in the list of values. The RANK.EQ function returns the lower rank, whereas the RANK.AVG function returns the average rank. -RANK.EQ(Value; Data; Type) +RANK.EQ(Value; Data [; Type]) Value is the value, whose rank is to be determined. Data is the array or range of data in the sample. Type (optional) is the sequence order. @@ -665,7 +665,7 @@

PROB

Returns the probability that values in a range are between two limits. If there is no End value, this function calculates the probability based on the principle that the Data values are equal to the value of Start. - PROB(Data; Probability; Start; End) + PROB(Data; Probability; Start [; End]) Data is the array or range of data in the sample. -- cgit