From 0c2b19daf2c1d08c53398f82da914e87aa4373f1 Mon Sep 17 00:00:00 2001 From: Steve Fanning Date: Sun, 31 May 2020 11:19:59 +0200 Subject: (04060118.xhp) Include square brackets in syntax sections to indicate optional parameters. ODF 1.2 used to confirm configuration of brackets for FV(), NPER(),and RATE(). Change-Id: I7b109974d3e1dbc6670c32628a5425741d882f4e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95208 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit cf09e34b35c8f0803ecfb5151bdbf1a1cf1ccc68) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95728 Reviewed-by: Ilmari Lauhakangas --- source/text/scalc/01/04060118.xhp | 34 +++++++++++++++++----------------- 1 file changed, 17 insertions(+), 17 deletions(-) diff --git a/source/text/scalc/01/04060118.xhp b/source/text/scalc/01/04060118.xhp index 850d2b1c81..a51d0cf6be 100644 --- a/source/text/scalc/01/04060118.xhp +++ b/source/text/scalc/01/04060118.xhp @@ -43,7 +43,7 @@ Calculates the price per 100 currency units par value of a security, if the first interest date falls irregularly. -ODDFPRICE(Settlement; Maturity; Issue; FirstCoupon; Rate; Yield; Redemption; Frequency; Basis) +ODDFPRICE(Settlement; Maturity; Issue; FirstCoupon; Rate; Yield; Redemption; Frequency [; Basis]) Settlement is the date of purchase of the security. Maturity is the date on which the security matures (expires). Issue is the date of issue of the security. @@ -66,7 +66,7 @@ Calculates the yield of a security if the first interest date falls irregularly. -ODDFYIELD(Settlement; Maturity; Issue; FirstCoupon; Rate; Price; Redemption; Frequency; Basis) +ODDFYIELD(Settlement; Maturity; Issue; FirstCoupon; Rate; Price; Redemption; Frequency [; Basis]) Settlement is the date of purchase of the security. Maturity is the date on which the security matures (expires). Issue is the date of issue of the security. @@ -89,7 +89,7 @@ Calculates the price per 100 currency units par value of a security, if the last interest date falls irregularly. -ODDLPRICE(Settlement; Maturity; LastInterest; Rate; Yield; Redemption; Frequency; Basis) +ODDLPRICE(Settlement; Maturity; LastInterest; Rate; Yield; Redemption; Frequency [; Basis]) Settlement is the date of purchase of the security. Maturity is the date on which the security matures (expires). LastInterest is the last interest date of the security. @@ -116,7 +116,7 @@ Calculates the yield of a security if the last interest date falls irregularly. -ODDLYIELD(Settlement; Maturity; LastInterest; Rate; Price; Redemption; Frequency; Basis) +ODDLYIELD(Settlement; Maturity; LastInterest; Rate; Price; Redemption; Frequency [; Basis]) Settlement is the date of purchase of the security. Maturity is the date on which the security matures (expires). LastInterest is the last interest date of the security. @@ -145,7 +145,7 @@ Returns the depreciation of an asset for a specified or partial period using a variable declining balance method. -VDB(Cost; Salvage; Life; S; End; Factor; NoSwitch) +VDB(Cost; Salvage; Life; S; End [; Factor [; NoSwitch]]) Cost is the initial value of an asset. Salvage is the value of an asset at the end of the depreciation. Life is the depreciation duration of the asset. @@ -174,7 +174,7 @@ If the payments take place at regular intervals, use the IRR function. -XIRR(Values; Dates; Guess) +XIRR(Values; Dates [; Guess]) Values and Dates refer to a series of payments and the series of associated date values. The first pair of dates defines the start of the payment plan. All other date values must be later, but need not be in any order. The series of values must contain at least one negative and one positive value (receipts and deposits). Guess (optional) is a guess that can be input for the internal rate of return. The default is 10%. @@ -324,7 +324,7 @@ Returns the constant interest rate per period of an annuity. -RATE(NPer; Pmt; PV; FV; Type; Guess) +RATE(NPer; Pmt; PV [ ; [ FV ] [ ; [ Type ] [ ; Guess ] ] ]) NPer is the total number of periods, during which payments are made (payment period). Pmt is the constant payment (annuity) paid during each period. PV is the cash value in the sequence of payments. @@ -349,7 +349,7 @@ Calculates the annual interest rate that results when a security (or other item) is purchased at an investment value and sold at a redemption value. No interest is paid. -INTRATE(Settlement; Maturity; Investment; Redemption; Basis) +INTRATE(Settlement; Maturity; Investment; Redemption [; Basis]) Settlement is the date of purchase of the security. Maturity is the date on which the security is sold. Investment is the purchase price. @@ -372,7 +372,7 @@ Returns the date of the first interest date after the settlement date. Format the result as a date. -COUPNCD(Settlement; Maturity; Frequency; Basis) +COUPNCD(Settlement; Maturity; Frequency [; Basis]) Settlement is the date of purchase of the security. Maturity is the date on which the security matures (expires). Frequency is number of interest payments per year (1, 2 or 4). @@ -394,7 +394,7 @@ Returns the number of days in the current interest period in which the settlement date falls. -COUPDAYS(Settlement; Maturity; Frequency; Basis) +COUPDAYS(Settlement; Maturity; Frequency [; Basis]) Settlement is the date of purchase of the security. Maturity is the date on which the security matures (expires). Frequency is number of interest payments per year (1, 2 or 4). @@ -416,7 +416,7 @@ Returns the number of days from the settlement date until the next interest date. -COUPDAYSNC(Settlement; Maturity; Frequency; Basis) +COUPDAYSNC(Settlement; Maturity; Frequency [; Basis]) Settlement is the date of purchase of the security. Maturity is the date on which the security matures (expires). Frequency is number of interest payments per year (1, 2 or 4). @@ -440,7 +440,7 @@ Returns the number of days from the first day of interest payment on a security until the settlement date. -COUPDAYBS(Settlement; Maturity; Frequency; Basis) +COUPDAYBS(Settlement; Maturity; Frequency [; Basis]) Settlement is the date of purchase of the security. Maturity is the date on which the security matures (expires). Frequency is the number of interest payments per year (1, 2 or 4). @@ -463,7 +463,7 @@ Returns the date of the interest date prior to the settlement date. Format the result as a date. -COUPPCD(Settlement; Maturity; Frequency; Basis) +COUPPCD(Settlement; Maturity; Frequency [; Basis]) Settlement is the date of purchase of the security. Maturity is the date on which the security matures (expires). Frequency is the number of interest payments per year (1, 2 or 4). @@ -486,7 +486,7 @@ Returns the number of coupons (interest payments) between the settlement date and the maturity date. -COUPNUM(Settlement; Maturity; Frequency; Basis) +COUPNUM(Settlement; Maturity; Frequency [; Basis]) Settlement is the date of purchase of the security. Maturity is the date on which the security matures (expires). Frequency is the number of interest payments per year (1, 2 or 4). @@ -509,7 +509,7 @@ Calculates the periodic amortizement for an investment with regular payments and a constant interest rate. -IPMT(Rate; Period; NPer; PV; FV; Type) +IPMT(Rate; Period; NPer; PV [; FV [; Type]]) Rate is the periodic interest rate. Period is the period, for which the compound interest is calculated. Period=NPER if compound interest for the last period is calculated. NPer is the total number of periods, during which annuity is paid. @@ -535,7 +535,7 @@ Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value). -FV(Rate; NPer; Pmt; PV; Type) +FV(Rate; NPer; Pmt [ ; [ PV ] [ ; Type ] ]) Rate is the periodic interest rate. NPer is the total number of periods (payment period). Pmt is the annuity paid regularly per period. @@ -583,7 +583,7 @@ Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. -NPER(Rate; Pmt; PV; FV; Type) +NPER(Rate; Pmt; PV [ ; [ FV ] [ ; Type ] ]) Rate is the periodic interest rate. Pmt is the constant annuity paid in each period. PV is the present value (cash value) in a sequence of payments. -- cgit