diff options
| -rw-r--r-- | source/text/scalc/01/04060105.xhp | 41 | ||||
| -rw-r--r-- | source/text/scalc/01/04060107.xhp | 6 | ||||
| -rw-r--r-- | source/text/scalc/01/04060110.xhp | 7 | ||||
| -rw-r--r-- | source/text/scalc/01/04060185.xhp | 71 |
4 files changed, 62 insertions, 63 deletions
diff --git a/source/text/scalc/01/04060105.xhp b/source/text/scalc/01/04060105.xhp index 97c212d50e..c2de532c2a 100644 --- a/source/text/scalc/01/04060105.xhp +++ b/source/text/scalc/01/04060105.xhp @@ -31,25 +31,25 @@ <bookmark_value>Function Wizard; logical</bookmark_value> <bookmark_value>functions; logical functions</bookmark_value> </bookmark> -<paragraph xml-lang="en-US" id="hd_id3153484" role="heading" level="1">Logical Functions</paragraph> +<h1 id="hd_id3153484">Logical Functions</h1> <paragraph xml-lang="en-US" id="par_id3149312" role="paragraph"><variable id="logischtext">This category contains the <emph>Logical</emph> functions. </variable></paragraph> -<paragraph role="heading" id="hd_id631520887352751" level="3" xml-lang="en-US">Handling non-logical arguments in logical functions</paragraph> +<h3 id="hd_id631520887352751">Handling non-logical arguments in logical functions</h3> <list type="unordered"> <listitem> - <paragraph id="par_id431520887384579" role="listitem" xml-lang="en-US">Zero (0) is equivalent to FALSE and all other numbers are equivalent to TRUE.</paragraph> + <paragraph id="par_id431520887384579" role="listitem" xml-lang="en-US">Zero (0) is equivalent to FALSE and all other numbers are equivalent to TRUE.</paragraph> </listitem> <listitem> - <paragraph id="par_id881520887475288" role="listitem" xml-lang="en-US">Empty cells and text in cells are ignored.</paragraph> + <paragraph id="par_id881520887475288" role="listitem" xml-lang="en-US">Empty cells and text in cells are ignored.</paragraph> </listitem> <listitem> - <paragraph id="par_id461520887504085" role="listitem" xml-lang="en-US">A #VALUE error is raised if all arguments are ignored.</paragraph> + <paragraph id="par_id461520887504085" role="listitem" xml-lang="en-US">A #VALUE error is raised if all arguments are ignored.</paragraph> </listitem> <listitem> - <paragraph id="par_id591520888006686" role="listitem" xml-lang="en-US">A #VALUE error is raised if one argument is direct text (not text in a cell).</paragraph> + <paragraph id="par_id591520888006686" role="listitem" xml-lang="en-US">A #VALUE error is raised if one argument is direct text (not text in a cell).</paragraph> </listitem> <listitem> - <paragraph id="par_id321520889630477" role="listitem" xml-lang="en-US">Errors as argument lead to an error.</paragraph> + <paragraph id="par_id321520889630477" role="listitem" xml-lang="en-US">Errors as argument lead to an error.</paragraph> </listitem> </list> <section id="howtoget"> @@ -60,13 +60,12 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3147505"><bookmark_value>AND function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UND" id="bm_id3145320" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3147505" role="heading" level="2">AND</paragraph> +<h2 id="hd_id3147505">AND</h2> <paragraph xml-lang="en-US" id="par_id3153959" role="paragraph"><ahelp hid="HID_FUNC_UND">Returns TRUE if all arguments are TRUE.</ahelp> If one of the elements is FALSE, this function returns the FALSE value.</paragraph> <paragraph xml-lang="en-US" id="par_id3146100" role="paragraph">The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3159123" role="code">AND(LogicalValue1; LogicalValue2 ...LogicalValue30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3150038" role="paragraph"> - <emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range. The result is TRUE if the logical value in all cells within the cell range is TRUE.</paragraph> + <paragraph xml-lang="en-US" id="par_id3159123" role="code">AND(<embedvar href="text/scalc/01/ful_func.xhp#logical255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#logical255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3153123" role="paragraph">The logical values of entries 12<13; 14>12, and 7<6 are to be checked:</paragraph> <paragraph xml-lang="en-US" id="par_id3145632" role="paragraph"> @@ -78,7 +77,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3149015"><bookmark_value>FALSE function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FALSCH" id="bm_id3154678" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3149015" role="heading" level="2">FALSE</paragraph> +<h2 id="hd_id3149015">FALSE</h2> <paragraph xml-lang="en-US" id="par_id3149890" role="paragraph"><ahelp hid="HID_FUNC_FALSCH">Returns the logical value FALSE.</ahelp> The FALSE() function does not require any arguments, and always returns the logical value FALSE.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3150030" role="code">FALSE()</paragraph> @@ -92,7 +91,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3150141"><bookmark_value>IF function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WENN" id="bm_id3152789" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3150141" role="heading" level="2">IF</paragraph> +<h2 id="hd_id3150141">IF</h2> <paragraph xml-lang="en-US" id="par_id3148740" role="paragraph"><ahelp hid="HID_FUNC_WENN">Specifies a logical test to be performed.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3154558" role="code">IF(Test; ThenValue; OtherwiseValue)</paragraph> @@ -113,7 +112,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3155954"><bookmark_value>NOT function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NICHT" id="bm_id3145168" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3155954" role="heading" level="2">NOT</paragraph> +<h2 id="hd_id3155954">NOT</h2> <paragraph xml-lang="en-US" id="par_id3153570" role="paragraph"><ahelp hid="HID_FUNC_NICHT">Complements (inverts) a logical value.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3157996" role="code">NOT(LogicalValue)</paragraph> @@ -127,13 +126,12 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3148394"><bookmark_value>OR function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ODER" id="bm_id3155620" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3148394" role="heading" level="2">OR</paragraph> +<h2 id="hd_id3148394">OR</h2> <paragraph xml-lang="en-US" id="par_id3156060" role="paragraph"><ahelp hid="HID_FUNC_ODER">Returns TRUE if at least one argument is TRUE.</ahelp> This function returns the value FALSE, if all the arguments have the logical value FALSE.</paragraph> <paragraph xml-lang="en-US" id="par_id3148771" role="paragraph">The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3150468" role="code">OR(LogicalValue1; LogicalValue2 ...LogicalValue30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3155819" role="paragraph"> - <emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range.<comment>UFI: first try to fix bugtraq 4905779</comment></paragraph> + <paragraph xml-lang="en-US" id="par_id3150468" role="code">OR(<embedvar href="text/scalc/01/ful_func.xhp#logical255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#logical255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3154870" role="paragraph">The logical values of entries 12<11; 13>22, and 45=45 are to be checked.</paragraph> <paragraph xml-lang="en-US" id="par_id3155371" role="paragraph"> @@ -145,7 +143,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3156256"><bookmark_value>TRUE function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WAHR" id="bm_id3148426" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3156256" role="heading" level="2">TRUE</paragraph> +<h2 id="hd_id3156256">TRUE</h2> <paragraph xml-lang="en-US" id="par_id3155985" role="paragraph"><ahelp hid="HID_FUNC_WAHR">The logical value is set to TRUE.</ahelp> The TRUE() function does not require any arguments, and always returns the logical value TRUE.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3152590" role="code">TRUE()</paragraph> @@ -162,12 +160,13 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3156257"><bookmark_value>XOR function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_XOR" id="bm_id3148427" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3156257" role="heading" level="2">XOR</paragraph> +<h2 id="hd_id3156257">XOR</h2> <paragraph xml-lang="en-US" id="par_id3155987" role="paragraph"><ahelp hid="HID_FUNC_XOR">Returns true if an odd number of arguments evaluates to TRUE.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id3148772" role="paragraph">The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values.</paragraph> <embed href="text/scalc/00/avail_release.xhp#4.0"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3150469" role="code">XOR(LogicalValue1; LogicalValue2 ...LogicalValue30)</paragraph> + <paragraph xml-lang="en-US" id="par_id3150469" role="code">XOR(<embedvar href="text/scalc/01/ful_func.xhp#logical255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#logical255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3083286" role="paragraph"> <item type="input">=XOR(TRUE;TRUE)</item> returns FALSE</paragraph> diff --git a/source/text/scalc/01/04060107.xhp b/source/text/scalc/01/04060107.xhp index 93da1256fc..958e6ced79 100644 --- a/source/text/scalc/01/04060107.xhp +++ b/source/text/scalc/01/04060107.xhp @@ -986,9 +986,9 @@ <paragraph id="hd_id3163286" role="heading" level="2" xml-lang="en-US">SUMPRODUCT</paragraph> <paragraph id="par_id3163314" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMMENPRODUKT">Multiplies corresponding elements in the given arrays, and returns the sum of those products.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph id="par_id3163347" role="code" xml-lang="en-US">SUMPRODUCT(Array1; Array2; ...; Array30)</paragraph> - <paragraph id="par_id3163362" role="paragraph" xml-lang="en-US"><emph>Array1, Array2; ...; Array30</emph> represent arrays whose corresponding elements are to be multiplied.</paragraph> - <paragraph id="par_idN11B19" role="paragraph" xml-lang="en-US">At least one array must be part of the argument list. If only one array is given, all array elements are summed.</paragraph> + <paragraph id="par_id3163347" role="code" xml-lang="en-US">SUMPRODUCT(Array 1[; Array 2;][...;[Array 255]])</paragraph> + <paragraph id="par_id3163362" role="paragraph" xml-lang="en-US"><emph>Array 1[; Array 2;][...;[Array 255]]</emph> represent arrays whose corresponding elements are to be multiplied.</paragraph> + <paragraph id="par_idN11B19" role="paragraph" xml-lang="en-US">At least one array must be part of the argument list. If only one array is given, all array elements are summed. If more than one array is given, they must all be the same size.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <table id="tbl_id6215704"> <tablerow> diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp index 91ff8aa621..5f0bbc9c52 100644 --- a/source/text/scalc/01/04060110.xhp +++ b/source/text/scalc/01/04060110.xhp @@ -189,15 +189,12 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3149688"> <bookmark_value>CONCATENATE function</bookmark_value> </bookmark> - <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VERKETTEN" id="bm_id3153084" localize="false"/> - <h2 id="hd_id3149688">CONCATENATE</h2> <paragraph id="par_id3154524" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_VERKETTEN">Combines several text strings into one string.</ahelp></paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3155954" role="code" xml-lang="en-US">CONCATENATE( <embedvar href="text/scalc/01/ful_func.xhp#string255_1" markup="keep"/> )</paragraph> -<embed href="text/scalc/01/ful_func.xhp#string255"/> +<paragraph id="par_id3155954" role="code" xml-lang="en-US">CONCATENATE(<embedvar href="text/scalc/01/ful_func.xhp#string255_1" markup="keep"/>)</paragraph> +<paragraph role="paragraph" id="par_id781585222554150"><emph>String 1[; String 2][; … ;[String 255]]</emph> are strings or references to cells containing strings.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3150008" role="paragraph" xml-lang="en-US"> <item type="input">=CONCATENATE("Good ";"Morning ";"Mrs. ";"Doe")</item> returns: Good Morning Mrs. Doe.</paragraph> </section> diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp index 056953c3f7..38a0157d2d 100644 --- a/source/text/scalc/01/04060185.xhp +++ b/source/text/scalc/01/04060185.xhp @@ -158,12 +158,11 @@ <h2 id="hd_id3149143">STDEV</h2> <paragraph xml-lang="en-US" id="par_id3146888" role="paragraph"><ahelp hid="HID_FUNC_STABW">Estimates the standard deviation based on a sample.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3149946" role="code">STDEV(Number1; Number2; ...; Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3157904" role="paragraph"> - <emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149946" role="code">STDEV(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> + <paragraph id="par_id211585163957345" role="paragraph" xml-lang="en-US">The parameters should specify at least two values.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3149434" role="paragraph"> - <item type="input">=STDEV(A1:A50)</item> returns the estimated standard deviation based on the data referenced.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149434" role="paragraph"><input>=STDEV(A1:A50)</input> returns the estimated standard deviation based on the data referenced.</paragraph> </section> <section id="stdeva"> <bookmark xml-lang="en-US" branch="index" id="bm_id3144745"><bookmark_value>STDEVA function</bookmark_value> @@ -172,9 +171,10 @@ <h2 id="hd_id3144745">STDEVA</h2> <paragraph xml-lang="en-US" id="par_id3151234" role="paragraph"><ahelp hid="HID_FUNC_STABWA">Calculates the standard deviation of an estimation based on a sample.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3147422" role="code">STDEVA(Value1; Value2; ...; Value30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3154547" role="paragraph"> - <emph>Value1, Value2, ..., Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph> + + <paragraph xml-lang="en-US" id="par_id3147422" role="code">STDEVA(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> + <paragraph id="par_id981585163977014" role="paragraph" xml-lang="en-US">The parameters should specify at least two values. Text has the value 0.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3148581" role="paragraph"> <item type="input">=STDEVA(A1:A50)</item> returns the estimated standard deviation based on the data referenced.</paragraph> @@ -187,9 +187,9 @@ <h2 id="hd_id3149734">STDEVP</h2> <paragraph xml-lang="en-US" id="par_id3149187" role="paragraph"><ahelp hid="HID_FUNC_STABWN">Calculates the standard deviation based on the entire population.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3154392" role="code">STDEVP(Number1; Number2; ...; Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3155261" role="paragraph"> - <emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population.</paragraph> + + <paragraph xml-lang="en-US" id="par_id3154392" role="code">STDEVP(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3153933" role="paragraph"> <item type="input">=STDEVP(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph> @@ -204,8 +204,9 @@ <paragraph xml-lang="en-US" id="par_id2949187" role="paragraph"><ahelp hid="HID_FUNC_ST_DEV_P_MS">Calculates the standard deviation based on the entire population.</ahelp></paragraph> <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id2954392" role="code">STDEV.P(Number1; Number2; ...; Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id2955261" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population.</paragraph> + + <paragraph xml-lang="en-US" id="par_id2954392" role="code">STDEV.P(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2953933" role="paragraph"><item type="input">=STDEV.P(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph> </section> @@ -219,8 +220,10 @@ <paragraph xml-lang="en-US" id="par_id2849187" role="paragraph"><ahelp hid="HID_FUNC_ST_DEV_S">Calculates the standard deviation based on sample of the population.</ahelp></paragraph> <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id2854392" role="code">STDEV.S(Number1; Number2; ...; Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id2855261" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample of the population.</paragraph> + + <paragraph xml-lang="en-US" id="par_id2854392" role="code">STDEV.S(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> + <paragraph id="par_id671585163972431" role="paragraph" xml-lang="en-US">The parameters should specify at least two values.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2853933" role="paragraph"><item type="input">=STDEV.S(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph> </section> @@ -231,9 +234,9 @@ <h2 id="hd_id3154522">STDEVPA</h2> <paragraph xml-lang="en-US" id="par_id3149549" role="paragraph"><ahelp hid="HID_FUNC_STABWNA">Calculates the standard deviation based on the entire population.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3146851" role="code">STDEVPA(Value1; Value2; ...; Value30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3153109" role="paragraph"> - <emph>Value1, Value2, ..., Value30</emph> are values or ranges representing an entire population. Text has the value 0.</paragraph> + <paragraph xml-lang="en-US" id="par_id3146851" role="code">STDEVPA(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> + <paragraph id="par_id961585163990543" role="paragraph" xml-lang="en-US">Text has the value 0.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3145163" role="paragraph"> <item type="input">=STDEVPA(A1:A50)</item> returns the standard deviation of the data referenced.</paragraph> @@ -538,9 +541,10 @@ <h2 id="hd_id3153828">VAR</h2> <paragraph xml-lang="en-US" id="par_id3159165" role="paragraph"><ahelp hid="HID_FUNC_VARIANZ">Estimates the variance based on a sample.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3153054" role="code">VAR(Number1 ; Number2; ...; Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3148938" role="paragraph"> - <emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph> + + <paragraph xml-lang="en-US" id="par_id3153054" role="code">VAR(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> + <paragraph id="par_id721585215582420" role="paragraph" xml-lang="en-US">The parameters should specify at least two values.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3153575" role="paragraph"> <item type="input">=VAR(A1:A50)</item> @@ -556,8 +560,9 @@ <paragraph xml-lang="en-US" id="par_id2959165" role="paragraph"><ahelp hid="HID_FUNC_VAR_S">Estimates the variance based on a sample.</ahelp></paragraph> <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id2953054" role="code">VAR.S(Number1; Number2; ...; Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id2948938" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph> + <paragraph xml-lang="en-US" id="par_id2953054" role="code">VAR.S(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> + <paragraph id="par_id891585215590756" role="paragraph" xml-lang="en-US">The parameters should specify at least two values.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2953575" role="paragraph"><item type="input">=VAR.S(A1:A50)</item></paragraph> </section> @@ -568,9 +573,9 @@ <h2 id="hd_id3151045">VARA</h2> <paragraph xml-lang="en-US" id="par_id3155122" role="paragraph"><ahelp hid="HID_FUNC_VARIANZA">Estimates a variance based on a sample. The value of text is 0.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3149999" role="code">VARA(Value1; Value2; ...; Value30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3158421" role="paragraph"> - <emph>Value1, Value2, ..., Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149999" role="code">VARA(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> + <paragraph id="par_id451585215586628" role="paragraph" xml-lang="en-US">The parameters should specify at least two values.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3154279" role="paragraph"> <item type="input">=VARA(A1:A50)</item> @@ -583,9 +588,8 @@ <h2 id="hd_id3166441">VARP</h2> <paragraph xml-lang="en-US" id="par_id3159199" role="paragraph"><ahelp hid="HID_FUNC_VARIANZEN">Calculates a variance based on the entire population.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3147282" role="code">VARP(Number1; Number2; ...; Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3149793" role="paragraph"> - <emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population.</paragraph> + <paragraph xml-lang="en-US" id="par_id3147282" role="code">VARP(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3153385" role="paragraph"> <item type="input">=VARP(A1:A50)</item> @@ -600,8 +604,8 @@ <paragraph xml-lang="en-US" id="par_id2959199" role="paragraph"><ahelp hid="HID_FUNC_VAR_P_MS">Calculates a variance based on the entire population.</ahelp></paragraph> <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id2947282" role="code">VAR.P(Number1; Number2; ...; Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id2949793" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population.</paragraph> + <paragraph xml-lang="en-US" id="par_id2947282" role="code">VAR.P(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2953385" role="paragraph"><item type="input">=VAR.P(A1:A50)</item></paragraph> </section> @@ -612,9 +616,8 @@ <h2 id="hd_id3153688">VARPA</h2> <paragraph xml-lang="en-US" id="par_id3149109" role="paragraph"><ahelp hid="HID_FUNC_VARIANZENA">Calculates the variance based on the entire population. The value of text is 0.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3149967" role="code">VARPA(Value1; Value2; ...; Value30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3149920" role="paragraph"> - <emph>Value1, Value2, ..., Value30</emph> are values or ranges representing an entire population.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149967" role="code">VARPA(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3156203" role="paragraph"> <item type="input">=VARPA(A1:A50)</item> |