summaryrefslogtreecommitdiff
path: root/helpcontent2/source/text/scalc/01/04060107.xhp
diff options
context:
space:
mode:
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060107.xhp')
-rw-r--r--helpcontent2/source/text/scalc/01/04060107.xhp28
1 files changed, 14 insertions, 14 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060107.xhp b/helpcontent2/source/text/scalc/01/04060107.xhp
index 7e9b4fcd6b..4ce73cf5a9 100644
--- a/helpcontent2/source/text/scalc/01/04060107.xhp
+++ b/helpcontent2/source/text/scalc/01/04060107.xhp
@@ -360,7 +360,7 @@
<section id="Section14">
<bookmark xml-lang="en-US" branch="index" id="bm_id3158446"><bookmark_value>MUNIT function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_EINHEITSMATRIX" id="bm_id3151317" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EINHEITSMATRIX" id="bm_id3151317" localize="false"/>
<paragraph role="heading" id="hd_id3158446" xml-lang="en-US" level="2" l10n="U" oldref="12">MUNIT</paragraph>
<paragraph role="paragraph" id="par_id3154121" xml-lang="en-US" l10n="U" oldref="13"><ahelp hid="HID_FUNC_EINHEITSMATRIX">Returns the unitary square array of a certain size.</ahelp> The unitary array is a square array where the main diagonal elements equal 1 and all other array elements are equal to 0.</paragraph>
<paragraph role="heading" id="hd_id3155123" xml-lang="en-US" level="3" l10n="U" oldref="14">Syntax</paragraph>
@@ -380,7 +380,7 @@
<section id="Section13">
<bookmark xml-lang="en-US" branch="index" id="bm_id3159084"><bookmark_value>FREQUENCY function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_HAEUFIGKEIT" id="bm_id3153883" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HAEUFIGKEIT" id="bm_id3153883" localize="false"/>
<paragraph role="heading" id="hd_id3159084" xml-lang="en-US" level="2" l10n="U" oldref="22">FREQUENCY</paragraph>
<paragraph role="paragraph" id="par_id3145777" xml-lang="en-US" l10n="CHG" oldref="23"><ahelp hid="HID_FUNC_HAEUFIGKEIT">Indicates the frequency distribution in a one-column-array.</ahelp> The function counts the number of values in the Data array that are within the values given by the Classes array.</paragraph>
<paragraph role="heading" id="hd_id3153347" xml-lang="en-US" level="3" l10n="U" oldref="24">Syntax</paragraph>
@@ -589,7 +589,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3151030"><bookmark_value>MDETERM function</bookmark_value>
<bookmark_value>determinants</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MDET" id="bm_id3154057" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MDET" id="bm_id3154057" localize="false"/>
<paragraph role="heading" id="hd_id3151030" xml-lang="en-US" level="2" l10n="U" oldref="31">MDETERM</paragraph>
<paragraph role="paragraph" id="par_id3154073" xml-lang="en-US" l10n="U" oldref="32"><ahelp hid="HID_FUNC_MDET">Returns the array determinant of an array.</ahelp> This function returns a value in the current cell; it is not necessary to define a range for the results.</paragraph>
<paragraph role="heading" id="hd_id3156366" xml-lang="en-US" level="3" l10n="U" oldref="33">Syntax</paragraph>
@@ -605,7 +605,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3151348"><bookmark_value>MINVERSE function</bookmark_value>
<bookmark_value>inverse arrays</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MINV" id="bm_id3151360" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINV" id="bm_id3151360" localize="false"/>
<paragraph role="heading" id="hd_id3151348" xml-lang="en-US" level="2" l10n="U" oldref="39">MINVERSE</paragraph>
<paragraph role="paragraph" id="par_id3145569" xml-lang="en-US" l10n="U" oldref="40"><ahelp hid="HID_FUNC_MINV">Returns the inverse array.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3156072" xml-lang="en-US" level="3" l10n="U" oldref="41">Syntax</paragraph>
@@ -621,7 +621,7 @@
<section id="Section10">
<bookmark xml-lang="en-US" branch="index" id="bm_id3148546"><bookmark_value>MMULT function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MMULT" id="bm_id3148501" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MMULT" id="bm_id3148501" localize="false"/>
<paragraph role="heading" id="hd_id3148546" xml-lang="en-US" level="2" l10n="U" oldref="47">MMULT</paragraph>
<paragraph role="paragraph" id="par_id3148518" xml-lang="en-US" l10n="U" oldref="48"><ahelp hid="HID_FUNC_MMULT">Calculates the array product of two arrays.</ahelp> The number of columns for array 1 must match the number of rows for array 2. The square array has an equal number of rows and columns.</paragraph>
<paragraph role="heading" id="hd_id3146767" xml-lang="en-US" level="3" l10n="U" oldref="49">Syntax</paragraph>
@@ -639,7 +639,7 @@
<section id="Section9">
<bookmark xml-lang="en-US" branch="index" id="bm_id3154970"><bookmark_value>TRANSPOSE function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MTRANS" id="bm_id3154982" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MTRANS" id="bm_id3154982" localize="false"/>
<paragraph role="heading" id="hd_id3154970" xml-lang="en-US" level="2" l10n="U" oldref="56">TRANSPOSE</paragraph>
<paragraph role="paragraph" id="par_id3155276" xml-lang="en-US" l10n="U" oldref="57"><ahelp hid="HID_FUNC_MTRANS">Transposes the rows and columns of an array.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3155294" xml-lang="en-US" level="3" l10n="U" oldref="58">Syntax</paragraph>
@@ -655,7 +655,7 @@
<section id="Section8">
<bookmark xml-lang="en-US" branch="index" id="bm_id3109846"><bookmark_value>LINEST function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_RGP" id="bm_id3144716" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RGP" id="bm_id3144716" localize="false"/>
<paragraph role="heading" id="hd_id3109846" xml-lang="en-US" level="2" l10n="U" oldref="64">LINEST</paragraph>
<paragraph role="paragraph" id="par_id3144733" xml-lang="en-US" l10n="CHG" oldref="65"><ahelp hid="HID_FUNC_RGP">Returns a table of statistics for a straight line that best fits a data set.</ahelp><comment>changed based on http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_LINEST_function (issue 76142)</comment></paragraph>
<paragraph role="heading" id="hd_id3152825" xml-lang="en-US" level="3" l10n="U" oldref="66">Syntax</paragraph>
@@ -1032,7 +1032,7 @@
<section id="Section7">
<bookmark xml-lang="en-US" branch="index" id="bm_id1596728"><bookmark_value>LOGEST function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_RKP" id="bm_id3146020" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RKP" id="bm_id3146020" localize="false"/>
<paragraph role="heading" id="hd_id3146009" xml-lang="en-US" level="2" l10n="U" oldref="150">LOGEST</paragraph>
<paragraph role="paragraph" id="par_id3146037" xml-lang="en-US" l10n="U" oldref="151"><ahelp hid="HID_FUNC_RKP">This function calculates the adjustment of the entered data as an exponential regression curve (y=b*m^x).</ahelp><comment>UFI: see http://support.microsoft.com/default.aspx?kbid=828528&amp;product=xl2003
for bug #i31051#</comment></paragraph>
@@ -1061,7 +1061,7 @@ for bug #i31051#</comment></paragraph>
<bookmark_value>dot products</bookmark_value>
<bookmark_value>inner products</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_SUMMENPRODUKT" id="bm_id3163297" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMENPRODUKT" id="bm_id3163297" localize="false"/>
<paragraph role="heading" id="hd_id3163286" xml-lang="en-US" level="2" l10n="U" oldref="161">SUMPRODUCT</paragraph>
<paragraph role="paragraph" id="par_id3163314" xml-lang="en-US" l10n="U" oldref="162"><ahelp hid="HID_FUNC_SUMMENPRODUKT">Multiplies corresponding elements in the given arrays, and returns the sum of those products.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3163334" xml-lang="en-US" level="3" l10n="U" oldref="163">Syntax</paragraph>
@@ -1176,7 +1176,7 @@ for bug #i31051#</comment></paragraph>
<section id="Section5">
<bookmark xml-lang="en-US" branch="index" id="bm_id3144842"><bookmark_value>SUMX2MY2 function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_SUMMEX2MY2" id="bm_id3144854" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMEX2MY2" id="bm_id3144854" localize="false"/>
<paragraph role="heading" id="hd_id3144842" xml-lang="en-US" level="2" l10n="U" oldref="169">SUMX2MY2</paragraph>
<paragraph role="paragraph" id="par_id3144871" xml-lang="en-US" l10n="U" oldref="170"><ahelp hid="HID_FUNC_SUMMEX2MY2">Returns the sum of the difference of squares of corresponding values in two arrays.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3144889" xml-lang="en-US" level="3" l10n="U" oldref="171">Syntax</paragraph>
@@ -1192,7 +1192,7 @@ for bug #i31051#</comment></paragraph>
<section id="Section4">
<bookmark xml-lang="en-US" branch="index" id="bm_id3145026"><bookmark_value>SUMX2PY2 function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_SUMMEX2PY2" id="bm_id3145038" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMEX2PY2" id="bm_id3145038" localize="false"/>
<paragraph role="heading" id="hd_id3145026" xml-lang="en-US" level="2" l10n="U" oldref="178">SUMX2PY2</paragraph>
<paragraph role="paragraph" id="par_id3145055" xml-lang="en-US" l10n="U" oldref="179"><ahelp hid="HID_FUNC_SUMMEX2PY2">Returns the sum of the sum of squares of corresponding values in two arrays.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3163390" xml-lang="en-US" level="3" l10n="U" oldref="180">Syntax</paragraph>
@@ -1208,7 +1208,7 @@ for bug #i31051#</comment></paragraph>
<section id="Section3">
<bookmark xml-lang="en-US" branch="index" id="bm_id3163527"><bookmark_value>SUMXMY2 function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_SUMMEXMY2" id="bm_id3163539" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMEXMY2" id="bm_id3163539" localize="false"/>
<paragraph role="heading" id="hd_id3163527" xml-lang="en-US" level="2" l10n="U" oldref="187">SUMXMY2</paragraph>
<paragraph role="paragraph" id="par_id3163556" xml-lang="en-US" l10n="U" oldref="188"><ahelp hid="HID_FUNC_SUMMEXMY2">Adds the squares of the variance between corresponding values in two arrays.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3163574" xml-lang="en-US" level="3" l10n="U" oldref="189">Syntax</paragraph>
@@ -1224,7 +1224,7 @@ for bug #i31051#</comment></paragraph>
<section id="Section2">
<bookmark xml-lang="en-US" branch="index" id="bm_id3166062"><bookmark_value>TREND function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_TREND" id="bm_id3166074" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TREND" id="bm_id3166074" localize="false"/>
<paragraph role="heading" id="hd_id3166062" xml-lang="en-US" level="2" l10n="U" oldref="196">TREND</paragraph>
<paragraph role="paragraph" id="par_id3166091" xml-lang="en-US" l10n="U" oldref="197"><ahelp hid="HID_FUNC_TREND">Returns values along a linear trend.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3166109" xml-lang="en-US" level="3" l10n="U" oldref="198">Syntax</paragraph>
@@ -1250,7 +1250,7 @@ for bug #i31051#</comment></paragraph>
<bookmark xml-lang="en-US" branch="index" id="bm_id3166317"><bookmark_value>GROWTH function</bookmark_value>
<bookmark_value>exponential trends in arrays</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_VARIATION" id="bm_id3166329" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIATION" id="bm_id3166329" localize="false"/>
<paragraph role="heading" id="hd_id3166317" xml-lang="en-US" level="2" l10n="U" oldref="207">GROWTH</paragraph>
<paragraph role="paragraph" id="par_id3166346" xml-lang="en-US" l10n="U" oldref="208"><ahelp hid="HID_FUNC_VARIATION">Calculates the points of an exponential trend in an array.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3166364" xml-lang="en-US" level="3" l10n="U" oldref="209">Syntax</paragraph>
generated by cgit (git 2.34.1) at 2024-07-11 14:48:06 +0000