summaryrefslogtreecommitdiff
path: root/source/text/scalc
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2020-07-10 10:01:10 -0300
committerAdolfo Jayme Barrientos <fitojb@ubuntu.com>2020-07-10 17:44:29 +0200
commit79e8a3820948824f875051058e4ed33cf822a529 (patch)
treed70fb8e477be766da7420ea99829083dca5b35b8 /source/text/scalc
parent93b76db773b5d3622c42906c346f4c10ac3f53eb (diff)
Fix mistake in Help page for VDB()
Change-Id: Ib3780415a1ca5385dd27391f2b33fd1904e5e24b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/98523 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
Diffstat (limited to 'source/text/scalc')
-rw-r--r--source/text/scalc/01/04060118.xhp44
1 files changed, 22 insertions, 22 deletions
diff --git a/source/text/scalc/01/04060118.xhp b/source/text/scalc/01/04060118.xhp
index a51d0cf6be..9b87de938b 100644
--- a/source/text/scalc/01/04060118.xhp
+++ b/source/text/scalc/01/04060118.xhp
@@ -28,7 +28,7 @@
<body>
-<paragraph id="hd_id3146780" role="heading" level="1" xml-lang="en-US">Financial Functions Part Three</paragraph>
+<h1 id="hd_id3146780">Financial Functions Part Three</h1>
<sort>
<section id="oddfprice">
@@ -39,7 +39,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ODDFPRICE" id="bm_id3146107" localize="false"/>
-<paragraph id="hd_id3145112" role="heading" level="2" xml-lang="en-US">ODDFPRICE</paragraph>
+<h2 id="hd_id3145112">ODDFPRICE</h2>
<paragraph id="par_id3147250" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_ODDFPRICE">Calculates the price per 100 currency units par value of a security, if the first interest date falls irregularly.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -62,7 +62,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ODDFYIELD" id="bm_id3149723" localize="false"/>
-<paragraph id="hd_id3157871" role="heading" level="2" xml-lang="en-US">ODDFYIELD</paragraph>
+<h2 id="hd_id3157871">ODDFYIELD</h2>
<paragraph id="par_id3147414" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_ODDFYIELD">Calculates the yield of a security if the first interest date falls irregularly.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -85,7 +85,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ODDLPRICE" id="bm_id3145596" localize="false"/>
-<paragraph id="hd_id3153933" role="heading" level="2" xml-lang="en-US">ODDLPRICE</paragraph>
+<h2 id="hd_id3153933">ODDLPRICE</h2>
<paragraph id="par_id3145145" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_ODDLPRICE">Calculates the price per 100 currency units par value of a security, if the last interest date falls irregularly.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -112,7 +112,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ODDLYIELD" id="bm_id3153732" localize="false"/>
-<paragraph id="hd_id3153564" role="heading" level="2" xml-lang="en-US">ODDLYIELD</paragraph>
+<h2 id="hd_id3153564">ODDLYIELD</h2>
<paragraph id="par_id3158002" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_ODDLYIELD">Calculates the yield of a security if the last interest date falls irregularly.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -141,11 +141,11 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VDB" id="bm_id3145624" localize="false"/>
-<paragraph id="hd_id3148768" role="heading" level="2" xml-lang="en-US">VDB</paragraph>
+<h2 id="hd_id3148768">VDB</h2>
<paragraph id="par_id3154636" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_VDB">Returns the depreciation of an asset for a specified or partial period using a variable declining balance method.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3149025" role="code" xml-lang="en-US">VDB(Cost; Salvage; Life; S; End [; Factor [; NoSwitch]])</paragraph>
+<paragraph id="par_id3149025" role="code" xml-lang="en-US">VDB(Cost; Salvage; Life; Start; End [; Factor [; NoSwitch]])</paragraph>
<paragraph id="par_id3150692" role="paragraph" xml-lang="en-US"><emph>Cost</emph> is the initial value of an asset.</paragraph>
<paragraph id="par_id3155369" role="paragraph" xml-lang="en-US"><emph>Salvage</emph> is the value of an asset at the end of the depreciation.</paragraph>
<paragraph id="par_id3154954" role="paragraph" xml-lang="en-US"><emph>Life</emph> is the depreciation duration of the asset.</paragraph>
@@ -169,7 +169,7 @@
<comment>mw changed "calculating;..." and "internal rates of return"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_XIRR" id="bm_id3083443" localize="false"/>
-<paragraph id="hd_id3147485" role="heading" level="2" xml-lang="en-US">XIRR</paragraph>
+<h2 id="hd_id3147485">XIRR</h2>
<paragraph id="par_id3145614" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_XIRR">Calculates the internal rate of return for a list of payments which take place on different dates.</ahelp> The calculation is based on a 365 days per year basis, ignoring leap years.</paragraph>
<paragraph id="par_idN10E62" role="paragraph" xml-lang="en-US">If the payments take place at regular intervals, use the <link href="text/scalc/01/04060103.xhp#irr" name="IRR">IRR</link> function.</paragraph>
@@ -274,7 +274,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_XNPV" id="bm_id3151172" localize="false"/>
-<paragraph id="hd_id3149198" role="heading" level="2" xml-lang="en-US">XNPV</paragraph>
+<h2 id="hd_id3149198">XNPV</h2>
<paragraph id="par_id3153904" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_XNPV">Calculates the capital value (net present value) for a list of payments which take place on different dates.</ahelp> The calculation is based on a 365 days per year basis, ignoring leap years.</paragraph>
<paragraph id="par_idN11138" role="paragraph" xml-lang="en-US">If the payments take place at regular intervals, use the <link href="text/scalc/01/04060119.xhp#npv" name="NPV">NPV</link> function.</paragraph>
@@ -296,7 +296,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZGZ" id="bm_id3146996" localize="false"/>
-<paragraph id="hd_id3148822" role="heading" level="2" xml-lang="en-US">RRI</paragraph>
+<h2 id="hd_id3148822">RRI</h2>
<paragraph id="par_id3154293" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ZGZ">Calculates the interest rate resulting from the profit (return) of an investment.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -320,7 +320,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZINS" id="bm_id3153581" localize="false"/>
-<paragraph id="hd_id3154267" role="heading" level="2" xml-lang="en-US">RATE</paragraph>
+<h2 id="hd_id3154267">RATE</h2>
<paragraph id="par_id3151052" role="paragraph" xml-lang="en-US"><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"/>
@@ -345,7 +345,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_INTRATE" id="bm_id3152944" localize="false"/>
-<paragraph id="hd_id3149106" role="heading" level="2" xml-lang="en-US">INTRATE</paragraph>
+<h2 id="hd_id3149106">INTRATE</h2>
<paragraph id="par_id3149918" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_INTRATE">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.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -368,7 +368,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_COUPNCD" id="bm_id3148413" localize="false"/>
-<paragraph id="hd_id3148654" role="heading" level="2" xml-lang="en-US">COUPNCD</paragraph>
+<h2 id="hd_id3148654">COUPNCD</h2>
<paragraph id="par_id3149927" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_COUPNCD">Returns the date of the first interest date after the settlement date. Format the result as a date.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -390,7 +390,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_COUPDAYS" id="bm_id3144759" localize="false"/>
-<paragraph id="hd_id3143281" role="heading" level="2" xml-lang="en-US">COUPDAYS</paragraph>
+<h2 id="hd_id3143281">COUPDAYS</h2>
<paragraph id="par_id3149488" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_COUPDAYS">Returns the number of days in the current interest period in which the settlement date falls.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -412,7 +412,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_COUPDAYSNC" id="bm_id3150941" localize="false"/>
-<paragraph id="hd_id3154832" role="heading" level="2" xml-lang="en-US">COUPDAYSNC</paragraph>
+<h2 id="hd_id3154832">COUPDAYSNC</h2>
<paragraph id="par_id3147100" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_COUPDAYSNC">Returns the number of days from the settlement date until the next interest date.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -436,7 +436,7 @@
<comment>mw added "durations;" and "securities;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_COUPDAYBS" id="bm_id3153775" localize="false"/>
-<paragraph id="hd_id3150408" role="heading" level="2" xml-lang="en-US">COUPDAYBS</paragraph>
+<h2 id="hd_id3150408">COUPDAYBS</h2>
<paragraph id="par_id3146795" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_COUPDAYBS">Returns the number of days from the first day of interest payment on a security until the settlement date.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -459,7 +459,7 @@
<comment>mw added "dates;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_COUPPCD" id="bm_id3149553" localize="false"/>
-<paragraph id="hd_id3152957" role="heading" level="2" xml-lang="en-US">COUPPCD</paragraph>
+<h2 id="hd_id3152957">COUPPCD</h2>
<paragraph id="par_id3153678" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_COUPPCD">Returns the date of the interest date prior to the settlement date. Format the result as a date.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -482,7 +482,7 @@
<comment>mw added "number..."</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_COUPNUM" id="bm_id3153348" localize="false"/>
-<paragraph id="hd_id3150673" role="heading" level="2" xml-lang="en-US">COUPNUM</paragraph>
+<h2 id="hd_id3150673">COUPNUM</h2>
<paragraph id="par_id3154350" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_COUPNUM">Returns the number of coupons (interest payments) between the settlement date and the maturity date.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -505,7 +505,7 @@
<comment>mw added "periodic..."</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZINSZ" id="bm_id3149737" localize="false"/>
-<paragraph id="hd_id3149339" role="heading" level="2" xml-lang="en-US">IPMT</paragraph>
+<h2 id="hd_id3149339">IPMT</h2>
<paragraph id="par_id3154522" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ZINSZ">Calculates the periodic amortizement for an investment with regular payments and a constant interest rate.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -531,7 +531,7 @@
<comment>mw made "future values..." a two level entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZW" id="bm_id3156049" localize="false"/>
-<paragraph id="hd_id3151205" role="heading" level="2" xml-lang="en-US">FV</paragraph>
+<h2 id="hd_id3151205">FV</h2>
<paragraph id="par_id3154140" role="paragraph" xml-lang="en-US"><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"/>
@@ -556,7 +556,7 @@
<comment>mw added "future values"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_FVSCHEDULE" id="bm_id3155341" localize="false"/>
-<paragraph id="hd_id3155912" role="heading" level="2" xml-lang="en-US">FVSCHEDULE</paragraph>
+<h2 id="hd_id3155912">FVSCHEDULE</h2>
<paragraph id="par_id3163726" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_FVSCHEDULE">Calculates the accumulated value of the starting capital for a series of periodically varying interest rates.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -579,7 +579,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZZR" id="bm_id3154917" localize="false"/>
-<paragraph id="hd_id3156435" role="heading" level="2" xml-lang="en-US">NPER</paragraph>
+<h2 id="hd_id3156435">NPER</h2>
<paragraph id="par_id3152363" role="paragraph" xml-lang="en-US"><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"/>