From e65f50a38a39945ded8e3abefde0a309ea98fb8c Mon Sep 17 00:00:00 2001 From: Steve Fanning Date: Wed, 27 May 2020 17:08:42 +0200 Subject: Update syntax section for six functions to include square brackets, indicating optional parameters. Change-Id: I27d069e76e448b2f019bd8678a1769b82f2f5c20 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94952 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 98cb0fc30637973a7ff8d15b86ec22a34a813c5a) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95686 Reviewed-by: Ilmari Lauhakangas --- source/text/scalc/01/04060106.xhp | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index a226f36372..7b8658a385 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -660,7 +660,7 @@ Returns the logarithm of a number to the specified base. -LOG(Number; Base) +LOG(Number[; Base]) Number is the value whose logarithm is to be calculated. Base (optional) is the base for the logarithm calculation. If omitted, Base 10 is assumed. @@ -872,7 +872,7 @@ Rounds a number to a certain number of decimal places. -ROUND(Number; Count) +ROUND(Number[; Count]) Returns Number rounded to Count decimal places. If Count is omitted or zero, the function rounds to the nearest integer. If Count is negative, the function rounds to the nearest 10, 100, 1000, etc. This function rounds to the nearest number. See ROUNDDOWN and ROUNDUP for alternatives. @@ -895,7 +895,7 @@ Rounds a number down, toward zero, to a certain precision. -ROUNDDOWN(Number; Count) +ROUNDDOWN(Number[; Count]) Returns Number rounded down (towards zero) to Count decimal places. If Count is omitted or zero, the function rounds down to an integer. If Count is negative, the function rounds down to the next 10, 100, 1000, etc. This function rounds towards zero. See ROUNDUP and ROUND for alternatives. @@ -917,7 +917,7 @@ Rounds a number up, away from zero, to a certain precision. -ROUNDUP(Number; Count) +ROUNDUP(Number[; Count]) Returns Number rounded up (away from zero) to Count decimal places. If Count is omitted or zero, the function rounds up to an integer. If Count is negative, the function rounds up to the next 10, 100, 1000, etc. This function rounds away from zero. See ROUNDDOWN and ROUND for alternatives. @@ -1049,7 +1049,7 @@ Adds the cells specified by a given criteria. This function is used to browse a range when you search for a certain value. -SUMIF(Range; Criteria; SumRange) +SUMIF(Range; Criteria[; SumRange]) Range is the range to which the criteria are to be applied. Criteria is the cell in which the search criterion is shown, or the search criterion itself. If the criteria is written into the formula, it has to be surrounded by double quotes. SumRange is the range from which values are summed. If this parameter has not been indicated, the values found in the Range are summed. @@ -1368,7 +1368,7 @@ Converts between old European national currency and to and from Euros. -EUROCONVERT(Value; "From_currency"; "To_currency", full_precision, triangulation_precision) +EUROCONVERT(Value; "From_currency"; "To_currency"[; full_precision][; triangulation_precision]) Value is the amount of the currency to be converted. From_currency and To_currency are the currency units to convert from and to respectively. These must be text, the official abbreviation for the currency (for example, "EUR"). The rates (shown per Euro) were set by the European Commission. Full_precision is optional. If omitted or False, the result is rounded according to the decimals of the To currency. If Full_precision is True, the result is not rounded. -- cgit