From 57cebf3f2226c19b642785afc2881c189090f944 Mon Sep 17 00:00:00 2001 From: Steve Fanning Date: Fri, 29 May 2020 16:36:35 +0200 Subject: (04060103.xhp) Corrections to function syntax statements Change-Id: Ic058b98ada2d384ef8128776bdbef9f73afe870a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95117 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit c6213b839442ecafd54eb6396e63b058a00af376) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95710 Reviewed-by: Ilmari Lauhakangas --- source/text/scalc/01/04060103.xhp | 22 +++++++++++----------- 1 file changed, 11 insertions(+), 11 deletions(-) diff --git a/source/text/scalc/01/04060103.xhp b/source/text/scalc/01/04060103.xhp index de2ac6669b..8a8efbffb8 100644 --- a/source/text/scalc/01/04060103.xhp +++ b/source/text/scalc/01/04060103.xhp @@ -44,7 +44,7 @@

AMORDEGRC

Calculates the amount of depreciation for a settlement period as degressive amortization. Unlike AMORLINC, a depreciation coefficient that is independent of the depreciable life is used here. - AMORDEGRC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate[; Basis]) + AMORDEGRC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate [; Basis]) Cost is the acquisition costs. @@ -67,7 +67,7 @@

AMORLINC

Calculates the amount of depreciation for a settlement period as linear amortization. If the capital asset is purchased during the settlement period, the proportional amount of depreciation is considered. - AMORLINC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate[; Basis]) + AMORLINC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate [; Basis]) Cost means the acquisition costs. @@ -91,7 +91,7 @@ mw changed "accrued interests" Calculates the accrued interest of a security in the case of periodic payments. - ACCRINT(Issue; FirstInterest; Settlement; Rate; [Par]; Frequency[; Basis]) + ACCRINT(Issue; FirstInterest; Settlement; Rate; [Par]; Frequency [; Basis]) Issue (required) is the issue date of the security. @@ -118,7 +118,7 @@

ACCRINTM

Calculates the accrued interest of a security in the case of one-off payment at the settlement date. - ACCRINTM(Issue; Settlement; Rate[; Par][; Basis]) + ACCRINTM(Issue; Settlement; Rate [; Par [; Basis]]) Issue (required) is the issue date of the security. @@ -141,7 +141,7 @@

RECEIVED

Calculates the amount received that is paid for a fixed-interest security at a given point in time. - RECEIVED(Settlement; Maturity; Investment; Discount[; Basis]) + RECEIVED(Settlement; Maturity; Investment; Discount [; Basis]) Settlement is the date of purchase of the security. @@ -168,7 +168,7 @@ Use this function to calculate the amount of money needed to be invested at a fixed rate today, to receive a specific amount, an annuity, over a specified number of periods. You can also determine how much money is to remain after the elapse of the period. Specify as well if the amount is to be paid out at the beginning or at the end of each period. Enter these values either as numbers, expressions or references. If, for example, interest is paid annually at 8%, but you want to use month as your period, enter 8%/12 under Rate and %PRODUCTNAME Calc with automatically calculate the correct factor. - PV(Rate; NPer; Pmt[; FV][; Type]) + PV(Rate; NPer; Pmt [; FV [; Type]]) Rate defines the interest rate per period. @@ -541,7 +541,7 @@

DISC

Calculates the allowance (discount) of a security as a percentage. - DISC(Settlement; Maturity; Price; Redemption[; Basis]) + DISC(Settlement; Maturity; Price; Redemption [; Basis]) Settlement is the date of purchase of the security. @@ -565,7 +565,7 @@ Calculates the duration of a fixed interest security in years. - DURATION(Settlement; Maturity; Coupon; Yield; Frequency[; Basis]) + DURATION(Settlement; Maturity; Coupon; Yield; Frequency [; Basis]) Settlement is the date of purchase of the security. @@ -632,7 +632,7 @@ Returns the depreciation of an asset for a specified period using the arithmetic-declining method. Use this form of depreciation if you require a higher initial depreciation value as opposed to linear depreciation. The depreciation value gets less with each period and is usually used for assets whose value loss is higher shortly after purchase (for example, vehicles, computers). Please note that the book value will never reach zero under this calculation type. - DDB(Cost; Salvage; Life; Period[; Factor]) + DDB(Cost; Salvage; Life; Period [; Factor]) Cost fixes the initial cost of an asset. @@ -659,7 +659,7 @@ Returns the depreciation of an asset for a specified period using the fixed-declining balance method. This form of depreciation is used if you want to get a higher depreciation value at the beginning of the depreciation (as opposed to linear depreciation). The depreciation value is reduced with every depreciation period by the depreciation already deducted from the initial cost. - DB(Cost; Salvage; Life; Period[; Month]) + DB(Cost; Salvage; Life; Period [; Month]) Cost is the initial cost of an asset. @@ -686,7 +686,7 @@ Calculates the internal rate of return for an investment. The values represent cash flow values at regular intervals, at least one value must be negative (payments), and at least one value must be positive (income). If the payments take place at irregular intervals, use the XIRR function. - IRR(Values[; Guess]) + IRR(Values [; Guess]) Values represents an array containing the values. -- cgit