diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060106.xhp')
-rw-r--r-- | helpcontent2/source/text/scalc/01/04060106.xhp | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060106.xhp b/helpcontent2/source/text/scalc/01/04060106.xhp index 0774564c79..21fb8c8071 100644 --- a/helpcontent2/source/text/scalc/01/04060106.xhp +++ b/helpcontent2/source/text/scalc/01/04060106.xhp @@ -592,7 +592,7 @@ oldref="284">Syntax</paragraph> <paragraph xml-lang="en-US" id="par_id3145765" role="code" l10n="CHG" oldref="285">COMBINA(Count1; Count2)</paragraph> <paragraph xml-lang="en-US" id="par_id3153372" role="paragraph" l10n="CHG" oldref="286"><emph>Count1</emph> is the number of items in the set.</paragraph> <paragraph xml-lang="en-US" id="par_id3155544" role="paragraph" l10n="CHG" oldref="287"><emph>Count2</emph> is the number of items to choose from the set.</paragraph> -<paragraph xml-lang="en-US" id="par_id1997131" role="paragraph" l10n="CHG">COMBINA returns the number of unique ways to choose these items, where the order of choosing is irrelevant, and repetition of items is allowed. For example if there are 3 items A, B and C in a set, you can choose 2 items in 6 different ways, namely AB, BA, AC, CA, BC and CB.</paragraph> +<paragraph xml-lang="en-US" id="par_id1997131" role="paragraph" l10n="CHG">COMBINA returns the number of unique ways to choose these items, where the order of choosing is irrelevant, and repetition of items is allowed. For example if there are 3 items A, B and C in a set, you can choose 2 items in 6 different ways, namely AA, AB, AC, BB, BC and CC.</paragraph> <paragraph xml-lang="en-US" id="par_id2052064" role="paragraph" l10n="CHG">COMBINA implements the formula: (Count1+Count2-1)! / (Count2!(Count1-1)!)<comment>i88052</comment></paragraph> <paragraph xml-lang="en-US" id="hd_id3154584" role="heading" level="3" l10n="U" oldref="288">Example</paragraph> @@ -613,7 +613,7 @@ oldref="293">Syntax</paragraph> <paragraph xml-lang="en-US" id="par_id3150796" role="paragraph" l10n="CHG" oldref="295">Returns <emph>Number</emph> with at most <emph>Count</emph> decimal places. Excess decimal places are simply removed, irrespective of sign.</paragraph> <paragraph xml-lang="en-US" id="par_id3150816" role="paragraph" l10n="CHG" oldref="296"> <item type="literal">TRUNC(Number; 0)</item> behaves as <item type="literal">INT(Number)</item> for positive numbers, but effectively rounds towards zero for negative numbers.</paragraph> -<paragraph xml-lang="en-US" id="par_id3148548" role="warning" l10n="CHG" oldref="557">The <emph>visible</emph> decimal places of the result are specified in <link href="text/shared/optionen/01060500.xhp">Tools - Options - %PRODUCTNAME Calc - Calculate</link>.</paragraph> +<paragraph xml-lang="en-US" id="par_id3148548" role="warning" l10n="CHG" oldref="557">The <emph>visible</emph> decimal places of the result are specified in <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060500.xhp">%PRODUCTNAME Calc - Calculate</link>.</paragraph> <paragraph xml-lang="en-US" id="hd_id3152555" role="heading" level="3" l10n="U" oldref="297">Example</paragraph> <paragraph xml-lang="en-US" id="par_id3152569" role="paragraph" l10n="CHG" oldref="298"> @@ -740,14 +740,14 @@ oldref="640">Example</paragraph> <bookmark xml-lang="en-US" branch="hid/HID_FUNC_POTENZ" id="bm_id3155728" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3155717" role="heading" level="2" l10n="U" oldref="350">POWER</paragraph> -<paragraph xml-lang="en-US" id="par_id3159495" role="paragraph" l10n="CHG" oldref="351"><ahelp hid="HID_FUNC_POTENZ">Returns a number raised to a power.</ahelp></paragraph> +<paragraph xml-lang="en-US" id="par_id3159495" role="paragraph" l10n="CHG" oldref="351"><ahelp hid="HID_FUNC_POTENZ">Returns a number raised to another number.</ahelp></paragraph> <paragraph xml-lang="en-US" id="hd_id3159513" role="heading" level="3" l10n="U" oldref="352">Syntax</paragraph> -<paragraph xml-lang="en-US" id="par_id3159526" role="code" l10n="U" oldref="353">POWER(Base; Power)</paragraph> -<paragraph xml-lang="en-US" id="par_id3159540" role="paragraph" l10n="CHG" oldref="354">Returns <emph>Base</emph> raised to the power of <emph>Power</emph>.</paragraph> +<paragraph xml-lang="en-US" id="par_id3159526" role="code" l10n="U" oldref="353">POWER(Base; Exponent)</paragraph> +<paragraph xml-lang="en-US" id="par_id3159540" role="paragraph" l10n="CHG" oldref="354">Returns <emph>Base</emph> raised to the power of <emph>Exponent</emph>.</paragraph> <paragraph xml-lang="en-US" id="par_id5081637" role="paragraph" l10n="NEW">The same result may be achieved by using the exponentiation operator ^:</paragraph> <paragraph xml-lang="en-US" id="par_id9759514" role="code" l10n="NEW"> -<item type="literal">Base^Power</item> +<item type="literal">Base^Exponent</item> </paragraph> <paragraph xml-lang="en-US" id="hd_id3159580" role="heading" level="3" l10n="U" oldref="356">Example</paragraph> |