diff options
| author | Steve Fanning <stevemfanning@yahoo.co.uk> | 2021-02-03 00:32:58 +0100 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2021-02-03 02:58:30 +0100 |
| commit | e5e4bb9f487ad1b1238d69254a4103ab303d6bb2 (patch) | |
| tree | 7aedc23bcae5b4a54679118556e8e3336f110893 /source | |
| parent | 13b1e7bca5e5860dbf4550949f514749a64e2d54 (diff) | |
Correct example given in Help file for Calc's DB function.
The explanation of the example given is confusing.
File 04060103.xhp is affected.
Change-Id: I7658d4d0497f83c68b2d56cfe14da48c1fe16b04
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110301
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/04060103.xhp | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/source/text/scalc/01/04060103.xhp b/source/text/scalc/01/04060103.xhp index 75bfec5bac..bfc194e17b 100644 --- a/source/text/scalc/01/04060103.xhp +++ b/source/text/scalc/01/04060103.xhp @@ -680,10 +680,9 @@ <paragraph xml-lang="en-US" id="par_id3150829" role="paragraph"> <emph>Month</emph> (optional) denotes the number of months for the first year of depreciation. If an entry is not defined, 12 is used as the default.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3156147" role="paragraph">A computer system with an initial cost of 25,000 currency units is to be depreciated over a three year period. The salvage value is to be 1,000 currency units. One period is 30 days.</paragraph> + <paragraph xml-lang="en-US" id="par_id3156147" role="paragraph">A computer system with an initial cost of 25,000 currency units is to be depreciated over a three-year period. The salvage value is to be 1,000 currency units. The first period of depreciation comprises 6 months. What is the fixed-declining balance depreciation of the computer system in the second period, which is a full year starting from the end of the first six-month period?</paragraph> <paragraph xml-lang="en-US" id="par_id3149513" role="paragraph"> - <item type="input">=DB(25000;1000;36;1;6)</item> = 1,075.00 currency units</paragraph> - <paragraph xml-lang="en-US" id="par_id3159242" role="paragraph">The fixed-declining depreciation of the computer system is 1,075.00 currency units.</paragraph> + <input>=DB(25000; 1000; 3; 2; 6)</input> returns 11,037.95 currency units.</paragraph> </section> <section id="irr"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153948"><bookmark_value>IRR function</bookmark_value> |