summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--source/text/scalc/01/04060106.xhp12
1 files 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 @@
<paragraph id="par_id3109841" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LOG">Returns the logarithm of a number to the specified base.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3144732" role="code" xml-lang="en-US">LOG(Number; Base)</paragraph>
+<paragraph id="par_id3144732" role="code" xml-lang="en-US">LOG(Number[; Base])</paragraph>
<paragraph id="par_id3144746" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the value whose logarithm is to be calculated.</paragraph>
<paragraph id="par_id3152840" role="paragraph" xml-lang="en-US"><emph>Base</emph> (optional) is the base for the logarithm calculation. If omitted, Base 10 is assumed.</paragraph>
@@ -872,7 +872,7 @@
<paragraph id="par_id3158150" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_RUNDEN">Rounds a number to a certain number of decimal places.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3158182" role="code" xml-lang="en-US">ROUND(Number; Count)</paragraph>
+<paragraph id="par_id3158182" role="code" xml-lang="en-US">ROUND(Number[; Count])</paragraph>
<paragraph id="par_id3158196" role="paragraph" xml-lang="en-US">Returns <emph>Number</emph> rounded to <emph>Count</emph> 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.</paragraph>
<paragraph id="par_id599688" role="paragraph" xml-lang="en-US">This function rounds to the nearest number. See ROUNDDOWN and ROUNDUP for alternatives.</paragraph>
@@ -895,7 +895,7 @@
<paragraph id="par_id3146020" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ABRUNDEN">Rounds a number down, toward zero, to a certain precision.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3146051" role="code" xml-lang="en-US">ROUNDDOWN(Number; Count)</paragraph>
+<paragraph id="par_id3146051" role="code" xml-lang="en-US">ROUNDDOWN(Number[; Count])</paragraph>
<paragraph id="par_id3146064" role="paragraph" xml-lang="en-US">Returns <emph>Number</emph> rounded down (towards zero) to <emph>Count</emph> 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.</paragraph>
<paragraph id="par_id2188787" role="paragraph" xml-lang="en-US">This function rounds towards zero. See ROUNDUP and ROUND for alternatives.</paragraph>
@@ -917,7 +917,7 @@
<paragraph id="par_id3163297" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_AUFRUNDEN">Rounds a number up, away from zero, to a certain precision.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3163328" role="code" xml-lang="en-US">ROUNDUP(Number; Count)</paragraph>
+<paragraph id="par_id3163328" role="code" xml-lang="en-US">ROUNDUP(Number[; Count])</paragraph>
<paragraph id="par_id3163342" role="paragraph" xml-lang="en-US">Returns <emph>Number</emph> rounded up (away from zero) to <emph>Count</emph> 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.</paragraph>
<paragraph id="par_id9573961" role="paragraph" xml-lang="en-US">This function rounds away from zero. See ROUNDDOWN and ROUND for alternatives.</paragraph>
@@ -1049,7 +1049,7 @@
<paragraph id="par_id3151986" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMMEWENN">Adds the cells specified by a given criteria.</ahelp> This function is used to browse a range when you search for a certain value.</paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3152028" role="code" xml-lang="en-US">SUMIF(Range; Criteria; SumRange)</paragraph>
+<paragraph id="par_id3152028" role="code" xml-lang="en-US">SUMIF(Range; Criteria[; SumRange])</paragraph>
<paragraph id="par_id3152043" role="paragraph" xml-lang="en-US"><emph>Range</emph> is the range to which the criteria are to be applied.</paragraph>
<paragraph id="par_id3152062" role="paragraph" xml-lang="en-US"><emph>Criteria</emph> 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.</paragraph>
<paragraph id="par_id3152083" role="paragraph" xml-lang="en-US"><emph>SumRange</emph> is the range from which values are summed. If this parameter has not been indicated, the values found in the Range are summed.</paragraph>
@@ -1368,7 +1368,7 @@
<paragraph id="par_id3143708" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_UMRECHNEN">Converts between old European national currency and to and from Euros.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3143748" role="code" xml-lang="en-US">EUROCONVERT(Value; "From_currency"; "To_currency", full_precision, triangulation_precision)</paragraph>
+<paragraph id="par_id3143748" role="code" xml-lang="en-US">EUROCONVERT(Value; "From_currency"; "To_currency"[; full_precision][; triangulation_precision])</paragraph>
<paragraph id="par_id3143763" role="paragraph" xml-lang="en-US"><emph>Value</emph> is the amount of the currency to be converted.</paragraph>
<paragraph id="par_id3143782" role="paragraph" xml-lang="en-US"><emph>From_currency</emph> and <emph>To_currency</emph> 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.</paragraph>
<paragraph id="par_id0119200904301810" role="paragraph" xml-lang="en-US"><emph>Full_precision</emph> 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.</paragraph>