diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060107.xhp')
-rw-r--r-- | helpcontent2/source/text/scalc/01/04060107.xhp | 28 |
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&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> |