source/text/scalc/00/00000004.xhp | 7 +++---- source/text/scalc/01/04060103.xhp | 2 +- source/text/scalc/01/04060105.xhp | 2 +- source/text/scalc/01/04060107.xhp | 8 ++++---- source/text/scalc/01/04060109.xhp | 4 +--- source/text/scalc/01/04060118.xhp | 18 +++++++----------- source/text/scalc/01/04060119.xhp | 4 ++-- source/text/scalc/01/04060181.xhp | 10 ++++------ source/text/scalc/01/func_style.xhp | 3 +-- 9 files changed, 24 insertions(+), 34 deletions(-)
New commits: commit f6e13066163c5e3b133248a1a5ceea0f23626dc1 Author: Olivier Hallot <[email protected]> AuthorDate: Sun Sep 20 20:22:52 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Mon Sep 21 10:52:42 2026 +0200 Fix syntax of some financial functions Change-Id: I4aa09dbca637a213d87b79d8934f9b0c5ee4c1f9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/211270 Reviewed-by: Olivier Hallot <[email protected]> Tested-by: Jenkins diff --git a/source/text/scalc/00/00000004.xhp b/source/text/scalc/00/00000004.xhp index 80966c4d35..1fb796ba03 100644 --- a/source/text/scalc/00/00000004.xhp +++ b/source/text/scalc/00/00000004.xhp @@ -20,14 +20,13 @@ <meta> <topic id="textscalc0000000004xml" indexer="exclude" status="PUBLISH"> - <title id="tit" xml-lang="en-US">To access this function...</title> + <title id="tit">To access this function...</title> <filename>/text/scalc/00/00000004.xhp</filename> </topic> </meta> <body> <h1 id="hd_id3155535"><variable id="wie">To access this function...</variable></h1> -<paragraph role="paragraph" id="par_idN1056E" xml-lang="en-US"><variable id="moreontop">More explanations on top of this page.</variable></paragraph> -<paragraph role="note" id="par_idN105AF" xml-lang="en-US"><variable id="optional">In the %PRODUCTNAME Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.</variable><comment>UFI: see #i43239# and #i3879#</comment></paragraph> -<paragraph role="paragraph" id="par_id9751884" xml-lang="en-US"><variable id="codes">Codes greater than 127 may depend on your system's character mapping (for example iso-8859-1, iso-8859-2, Windows-1252, Windows-1250), and hence may not be portable.</variable></paragraph> +<paragraph role="paragraph" id="par_idN1056E"><variable id="moreontop">More explanations on top of this page.</variable></paragraph> +<paragraph role="paragraph" id="par_id9751884"><variable id="codes">Codes greater than 127 may depend on your system's character mapping (for example iso-8859-1, iso-8859-2, Windows-1252, Windows-1250), and hence may not be portable.</variable></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/04060103.xhp b/source/text/scalc/01/04060103.xhp index bfde3b25e0..ba8dfd0f18 100644 --- a/source/text/scalc/01/04060103.xhp +++ b/source/text/scalc/01/04060103.xhp @@ -192,7 +192,7 @@ <emph>FV</emph> (optional) defines the future value remaining after the final installment has been made.</paragraph> <paragraph id="par_id3146883" role="paragraph"> <emph>Type</emph> (optional) denotes due date for payments. Type = 1 means due at the beginning of a period and Type = 0 (default) means due at the end of the period.</paragraph> - <paragraph id="par_idN10B13" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> + <embed href="text/scalc/01/common_func.xhp#optional_args"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3145225" role="paragraph">What is the present value of an investment, if 500 currency units are paid out monthly and the annual interest rate is 8%? The payment period is 48 months and 20,000 currency units are to remain at the end of the payment period.</paragraph> <paragraph id="par_id3155907" role="paragraph"> diff --git a/source/text/scalc/01/04060105.xhp b/source/text/scalc/01/04060105.xhp index 6283c38eba..df94b56cc5 100644 --- a/source/text/scalc/01/04060105.xhp +++ b/source/text/scalc/01/04060105.xhp @@ -117,7 +117,7 @@ <emph>ThenValue</emph> (optional) is the value that is returned if the logical test is TRUE.</paragraph> <paragraph id="par_id3154811" role="paragraph"> <emph>OtherwiseValue</emph> (optional) is the value that is returned if the logical test is FALSE.</paragraph> - <paragraph id="par_idN107FA" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> + <embed href="text/scalc/01/common_func.xhp#optional_args"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3150867" role="paragraph"> <input>=IF(A1>5;100;"too small")</input> If the value in <literal>A1</literal> is greater than <literal>5</literal>, the value <literal>100</literal> is returned; otherwise, the text <literal>too small</literal> is returned.</paragraph> diff --git a/source/text/scalc/01/04060107.xhp b/source/text/scalc/01/04060107.xhp index a174231ec0..df264ea628 100644 --- a/source/text/scalc/01/04060107.xhp +++ b/source/text/scalc/01/04060107.xhp @@ -741,7 +741,7 @@ <paragraph id="par_id3154448" role="paragraph">If <emph>linearType</emph> is FALSE the straight line found is forced to pass through the origin (the constant a is zero; y = bx). If omitted, <emph>linearType</emph> defaults to TRUE (the line is not forced through the origin).</paragraph> <paragraph id="par_id3154142" role="paragraph">If <emph>stats</emph> is omitted or FALSE only the top line of the statistics table is returned. If TRUE the entire table is returned.</paragraph> <paragraph id="par_id0811200804502261" role="paragraph">LINEST returns a table (array) of statistics as below and must be entered as an array formula (for example by using <switchinline select="sys"><caseinline select="MAC"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Return</emph> rather than just <emph>Return</emph>).</paragraph> - <paragraph id="par_idN11416" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> + <embed href="text/scalc/01/common_func.xhp#optional_args"/> <paragraph id="par_idN116C6" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3154176" role="paragraph">This function returns an array and is handled in the same way as the other array functions. Select a range for the answers and then the function. Select <emph>data_Y</emph>. If you want, you can enter other parameters. Select <emph>Array</emph> and click <emph>OK</emph>.</paragraph> @@ -1011,7 +1011,7 @@ <paragraph id="par_id3163155" role="paragraph"><emph>DataX</emph> (optional) represents the X Data array.</paragraph> <paragraph id="par_id3163174" role="paragraph"><emph>FunctionType</emph> (optional). If Function_Type = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated.</paragraph> <paragraph id="par_id3163196" role="paragraph"><emph>Stats</emph> (optional). If Stats=0, only the regression coefficient is calculated.</paragraph> - <paragraph id="par_idN118F7" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> + <embed href="text/scalc/01/common_func.xhp#optional_args"/> <paragraph id="par_idN11BC3" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3163230" role="paragraph">See LINEST. However, no square sum will be returned.</paragraph> @@ -1158,7 +1158,7 @@ <paragraph id="par_id3166156" role="paragraph"><emph>DataX</emph> (optional) represents the X Data array.</paragraph> <paragraph id="par_id3166176" role="paragraph"><emph>NewDataX</emph> (optional) represents the array of the X data, which are used for recalculating values.</paragraph> <paragraph id="par_id3166196" role="paragraph"><emph>LinearType</emph> (optional). If LinearType = 0, then lines will be calculated through the zero point. Otherwise, offset lines will also be calculated. The default is LinearType <> 0.</paragraph> - <paragraph id="par_idN11D2F" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> + <embed href="text/scalc/01/common_func.xhp#optional_args"/> <paragraph id="par_idN12019" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3166245" role="paragraph">Select a spreadsheet range in which the trend data will appear. Select the function. Enter the output data or select it with the mouse. Mark the <emph>Array</emph> field, click <emph>OK</emph>. The trend data calculated from the output data is displayed.</paragraph> @@ -1177,7 +1177,7 @@ <paragraph id="par_id3166411" role="paragraph"><emph>DataX</emph> (optional) represents the X Data array.</paragraph> <paragraph id="par_id3173797" role="paragraph"><emph>NewDataX</emph> (optional) represents the X data array, in which the values are recalculated.</paragraph> <paragraph id="par_id3173817" role="paragraph"><emph>FunctionType</emph> (optional). If FunctionType = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated.</paragraph> - <paragraph id="par_idN11DFD" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> + <embed href="text/scalc/01/common_func.xhp#optional_args"/> <paragraph id="par_idN12113" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3173852" role="paragraph">This function returns an array and is handled in the same way as the other array functions. Select a range where you want the answers to appear and select the function. Select <emph>DataY</emph>. Enter any other parameters, mark <emph>Array</emph> and click <emph>OK</emph>.</paragraph> diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 8504fc83f9..976d981cb9 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -381,9 +381,7 @@ <paragraph id="par_id8662373" role="paragraph">Arguments <emph>Rows</emph> and <emph>Columns</emph> must not lead to zero or negative start row or column.</paragraph> <paragraph id="par_id9051484" role="paragraph">Arguments <emph>Height</emph> and <emph>Width</emph> must not lead to zero or negative count of rows or columns.</paragraph> <embed href="text/scalc/01/common_func.xhp#IntegerTrunc"/> - <paragraph id="par_idN1104B" role="paragraph" localize="false"> - <embedvar href="text/scalc/00/00000004.xhp#optional"/> - </paragraph> + <embed href="text/scalc/01/common_func.xhp#optional_args"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3149744" role="paragraph"> <item type="input">=OFFSET(A1;2;2)</item> returns the value in cell C3 (A1 moved by two rows and two columns down). If C3 contains the value <item type="input">100</item> this function returns the value 100.</paragraph> diff --git a/source/text/scalc/01/04060118.xhp b/source/text/scalc/01/04060118.xhp index 6b2a45db27..a50a007e48 100644 --- a/source/text/scalc/01/04060118.xhp +++ b/source/text/scalc/01/04060118.xhp @@ -153,8 +153,7 @@ <paragraph id="par_id3153221" role="paragraph"><emph>End</emph> is the end of the depreciation.</paragraph> <paragraph id="par_id3147536" role="paragraph"><emph>Factor</emph> (optional) is the depreciation factor. Factor = 2 is double rate depreciation.</paragraph> <paragraph id="par_id3154865" role="paragraph"><emph>NoSwitch</emph>is an optional parameter. NoSwitch = 0 (default) means a switch to linear depreciation. In NoSwitch = 1 no switch is made.</paragraph> -<paragraph id="par_idN10A0D" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> - +<embed href="text/scalc/01/common_func.xhp#optional_args"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3153927" role="paragraph">What is the declining-balance double-rate depreciation for a period if the initial cost is 35,000 currency units and the value at the end of the depreciation is 7,500 currency units. The depreciation period is 3 years. The depreciation from the 10th to the 20th period is calculated.</paragraph> <paragraph id="par_id3155991" role="paragraph"><item type="input">=VDB(35000;7500;36;10;20;2)</item> = 8603.80 currency units. The depreciation during the period between the 10th and the 20th period is 8,603.80 currency units.</paragraph> @@ -324,15 +323,14 @@ <paragraph id="par_id3151052" role="paragraph"><ahelp hid="HID_FUNC_ZINS">Returns the constant interest rate per period of an annuity.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3158423" role="code">RATE(NPer; Pmt; PV [ ; [ FV ] [ ; [ Type ] [ ; Guess ] ] ])</paragraph> +<paragraph id="par_id3158423" role="code">RATE(NPer; Pmt; PV [;FV [;Type [;Guess ]]])</paragraph> <paragraph id="par_id3148910" role="paragraph"><emph>NPer</emph> is the total number of periods, during which payments are made (payment period).</paragraph> <paragraph id="par_id3148925" role="paragraph"><emph>Pmt</emph> is the constant payment (annuity) paid during each period.</paragraph> <paragraph id="par_id3149160" role="paragraph"><emph>PV</emph> is the cash value in the sequence of payments.</paragraph> <paragraph id="par_id3166456" role="paragraph"><emph>FV</emph> (optional) is the future value, which is reached at the end of the periodic payments.</paragraph> <paragraph id="par_id3153243" role="paragraph"><emph>Type</emph> (optional) is the due date of the periodic payment, either at the beginning or at the end of a period.</paragraph> <paragraph id="par_id3146949" role="paragraph"><emph>Guess</emph> (optional) determines the estimated value of the interest with iterative calculation.</paragraph> -<paragraph id="par_idN10E2A" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> - +<embed href="text/scalc/01/common_func.xhp#optional_args"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3150706" role="paragraph">What is the constant interest rate for a payment period of 3 periods if 10 currency units are paid regularly and the present cash value is 900 currency units.</paragraph> <paragraph id="par_id3155586" role="paragraph"><item type="input">=RATE(3;-10;900)</item> = -75.63% The interest rate is therefore 75.63%.</paragraph> @@ -535,14 +533,13 @@ <paragraph id="par_id3154140" role="paragraph"><ahelp hid="HID_FUNC_ZW">Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3145215" role="code">FV(Rate; NPer; Pmt [ ; [ PV ] [ ; Type ] ])</paragraph> +<paragraph id="par_id3145215" role="code">FV(Rate; NPer; Pmt [; PV [; Type ]])</paragraph> <paragraph id="par_id3155136" role="paragraph"><emph>Rate</emph> is the periodic interest rate.</paragraph> <paragraph id="par_id3156029" role="paragraph"><emph>NPer</emph> is the total number of periods (payment period).</paragraph> <paragraph id="par_id3151322" role="paragraph"><emph>Pmt</emph> is the annuity paid regularly per period.</paragraph> <paragraph id="par_id3145256" role="paragraph"><emph>PV</emph> (optional) is the (present) cash value of an investment.</paragraph> <paragraph id="par_id3150999" role="paragraph"><emph>Type</emph> (optional) defines whether the payment is due at the beginning or the end of a period.</paragraph> -<paragraph id="par_idN114D8" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> - +<embed href="text/scalc/01/common_func.xhp#optional_args"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3146813" role="paragraph">What is the value at the end of an investment if the interest rate is 4% and the payment period is two years, with a periodic payment of 750 currency units. The investment has a present value of 2,500 currency units.</paragraph> <paragraph id="par_id3149302" role="paragraph"><input>=FV(4%;2;750;2500)</input> = -4234.00 currency units. The value at the end of the investment is 4234.00 currency units.</paragraph> @@ -584,14 +581,13 @@ <paragraph id="par_id3152363" role="paragraph"><ahelp hid="HID_FUNC_ZZR">Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3155934" role="code">NPER(Rate; Pmt; PV [ ; [ FV ] [ ; Type ] ])</paragraph> +<paragraph id="par_id3155934" role="code">NPER(Rate; Pmt; PV [;FV [;Type ]])</paragraph> <paragraph id="par_id3155946" role="paragraph"><emph>Rate</emph> is the periodic interest rate.</paragraph> <paragraph id="par_id3149042" role="paragraph"><emph>Pmt</emph> is the constant annuity paid in each period.</paragraph> <paragraph id="par_id3153134" role="paragraph"><emph>PV</emph> is the present value (cash value) in a sequence of payments.</paragraph> <paragraph id="par_id3154398" role="paragraph"><emph>FV</emph> (optional) is the future value, which is reached at the end of the last period.</paragraph> <paragraph id="par_id3145127" role="paragraph"><emph>Type</emph> (optional) is the due date of the payment at the beginning or at the end of the period.</paragraph> -<paragraph id="par_idN1166C" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> - +<embed href="text/scalc/01/common_func.xhp#optional_args"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3147378" role="paragraph">How many payment periods does a payment period cover with a periodic interest rate of 6%, a periodic payment of 153.75 currency units and a present cash value of 2.600 currency units.</paragraph> <paragraph id="par_id3156171" role="paragraph"><input>=NPER(6%;153.75;2600)</input> = -12,02. The payment period covers 12.02 periods.</paragraph> diff --git a/source/text/scalc/01/04060119.xhp b/source/text/scalc/01/04060119.xhp index 9e74cc66e0..e898ae7bd8 100644 --- a/source/text/scalc/01/04060119.xhp +++ b/source/text/scalc/01/04060119.xhp @@ -54,7 +54,7 @@ <emph>FV</emph> (optional) is the desired (future) value.</paragraph> <paragraph role="paragraph" id="par_id3144744"> <emph>Type</emph> (optional) defines the due date. F = 1 for payment at the beginning of a period and F = 0 for payment at the end of a period.</paragraph> -<paragraph role="paragraph" id="par_idN1067C" localize="false"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> +<embed href="text/scalc/01/common_func.xhp#optional_args"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3154811">How high is the periodic monthly payment at an annual interest rate of 8.75% over a period of 3 years? The cash value is 5,000 currency units and is always paid at the beginning of a period. The future value is 8,000 currency units.</paragraph> <paragraph role="paragraph" id="par_id3149246"> @@ -530,7 +530,7 @@ <emph>FV</emph> (optional) is the desired value (future value) to be reached at the end of the periodic payments.</paragraph> <paragraph role="paragraph" id="par_id3156434"> <emph>Type</emph> (optional) is the due date for the periodic payments. Type=1 is payment at the beginning and Type=0 is payment at the end of each period.</paragraph> -<paragraph role="paragraph" id="par_idN11645" localize="false"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> +<embed href="text/scalc/01/common_func.xhp#optional_args"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3154222">What are the periodic payments at a yearly interest rate of 1.99% if the payment time is 3 years and the cash value is 25,000 currency units. There are 36 months as 36 payment periods, and the interest rate per payment period is 1.99%/12.</paragraph> <paragraph role="paragraph" id="par_id3155943"> diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp index 9c86d4e925..27566cf9b0 100644 --- a/source/text/scalc/01/04060181.xhp +++ b/source/text/scalc/01/04060181.xhp @@ -208,7 +208,7 @@ <paragraph id="par_id3156306" role="paragraph"><emph>Beta</emph> is a strictly positive parameter of the Beta distribution.</paragraph> <paragraph id="par_id3150960" role="paragraph"><emph>Start</emph> (optional) is the lower bound of the output range of the function. If omitted, the default value is 0.</paragraph> <paragraph id="par_id3151268" role="paragraph"><emph>End</emph> (optional) is the upper bound of the output range of the function. If omitted, the default value is 1.</paragraph> -<paragraph id="par_idN109DF" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> +<embed href="text/scalc/01/common_func.xhp#optional_args"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3146859" role="paragraph"><input>=BETAINV(0.5;5;10)</input> returns the value 0.3257511553.</paragraph> <paragraph role="paragraph" id="par_id871621424421294"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/BETAINV";>BETAINV Wiki page</link></paragraph> @@ -231,7 +231,7 @@ <paragraph id="par_id2956306" role="paragraph"><emph>Beta</emph> is a strictly positive parameter of the Beta distribution.</paragraph> <paragraph id="par_id2950960" role="paragraph"><emph>Start</emph> (optional) is the lower bound of the output range of the function. If omitted, the default value is 0.</paragraph> <paragraph id="par_id2951268" role="paragraph"><emph>End</emph> (optional) is the upper bound of the output range of the function. If omitted, the default value is 1.</paragraph> -<paragraph id="par_idN109DFms" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> +<embed href="text/scalc/01/common_func.xhp#optional_args"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2946859" role="paragraph"><input>=BETA.INV(0.5;5;10)</input> returns the value 0.3257511553.</paragraph> <paragraph role="paragraph" id="par_id841621424421294"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/BETA.INV";>BETA.INV Wiki page</link></paragraph> @@ -260,8 +260,7 @@ <paragraph id="par_id3150254" role="paragraph"><emph>Start</emph> (optional) is the lower bound for <emph>Number</emph>.</paragraph> <paragraph id="par_id3149138" role="paragraph"><emph>End</emph> (optional) is the upper bound for <emph>Number</emph>.</paragraph> <paragraph id="par_id012020091254453" role="paragraph"><emph>Cumulative</emph> (optional) can be 0 or False to calculate the probability density function. It can be any other value or True or omitted to calculate the cumulative distribution function.</paragraph> -<paragraph id="par_idN10AB3" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> - +<embed href="text/scalc/01/common_func.xhp#optional_args"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3156118" role="paragraph"><item type="input">=BETADIST(0.75;3;4)</item> returns the value 0.96.</paragraph> </section> @@ -285,8 +284,7 @@ <paragraph id="par_id062920141254453" role="paragraph"><emph>Cumulative</emph> (required) can be 0 or False to calculate the probability density function. It can be any other value or True to calculate the cumulative distribution function.</paragraph> <paragraph id="par_id2950254" role="paragraph"><emph>Start</emph> (optional) is the lower bound for <emph>Number</emph>.</paragraph> <paragraph id="par_id2949138" role="paragraph"><emph>End</emph> (optional) is the upper bound for <emph>Number</emph>.</paragraph> -<paragraph id="par_idN10AB3ms" role="paragraph" localize="false"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> - +<embed href="text/scalc/01/common_func.xhp#optional_args"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2956118" role="paragraph"><item type="input">=BETA.DIST(2;8;10;1;1;3)</item> returns the value 0.6854706</paragraph> <paragraph id="par_id2956119" role="paragraph"><item type="input">=BETA.DIST(2;8;10;0;1;3)</item> returns the value 1.4837646</paragraph> diff --git a/source/text/scalc/01/func_style.xhp b/source/text/scalc/01/func_style.xhp index 643ba2af6b..6f63ba2305 100644 --- a/source/text/scalc/01/func_style.xhp +++ b/source/text/scalc/01/func_style.xhp @@ -41,8 +41,7 @@ <paragraph role="paragraph" id="par_id81673375703156"> <emph>Style2</emph> is the optional name of a cell style assigned to the cell after the time specified in the <emph>Time</emph> parameter has passed. If this parameter is missing the "Default" cell style is applied. </paragraph> - <note id="par_id971673376620554"><embedvar href="text/scalc/00/00000004.xhp#optional"/></note> - + <embed href="text/scalc/01/common_func.xhp#optional_args"/> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id491673376748686"> <input>=10+STYLE("Good",60,"Neutral")</input>
