Bug 131140 - [PATCH] Add a negative number to the example of NPV.
Summary: [PATCH] Add a negative number to the example of NPV.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-03-05 05:24 UTC by Hong Xu
Modified: 2020-05-11 03:48 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
patch (1.94 KB, patch)
2020-03-05 05:24 UTC, Hong Xu
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Hong Xu 2020-03-05 05:24:43 UTC
Created attachment 158399 [details]
patch

Otherwise the user may doubt whether negative numbers can be used.
---
 source/text/scalc/01/04060119.xhp | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/source/text/scalc/01/04060119.xhp b/source/text/scalc/01/04060119.xhp
index ea6686d20a1a..9805881768f1 100644
--- a/source/text/scalc/01/04060119.xhp
+++ b/source/text/scalc/01/04060119.xhp
@@ -338,9 +338,9 @@
 <paragraph role="paragraph" id="par_id3150427" xml-lang="en-US">
 <emph>Value1, Value2, ..., Value30</emph> are up to 30 values, which represent deposits or withdrawals.</paragraph>
 <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph role="paragraph" id="par_id3154800" xml-lang="en-US">What is the net present value of periodic payments of 10, 20 and 30 currency units with a discount rate of 8.75%. At time zero the costs were paid as -40 currency units.</paragraph>
+<paragraph role="paragraph" id="par_id3154800" xml-lang="en-US">What is the net present value of periodic payments of 10, 20, 30 and -5 currency units with a discount rate of 8.75%. At time zero the costs were paid as -40 currency units.</paragraph>
 <paragraph role="paragraph" id="par_id3143270" xml-lang="en-US">
-<item type="input">=NPV(8.75%;10;20;30)</item> = 49.43 currency units. The net present value is the returned value minus the initial costs of 40 currency units, therefore 9.43 currency units.</paragraph>
+<item type="input">=NPV(8.75%;10;20;30;-5)</item> = 45.68 currency units. The net present value is the returned value minus the initial costs of 40 currency units, therefore 5.68 currency units.</paragraph>
 </section>
 <section id="nominal">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3149484"><bookmark_value>calculating;nominal interest rates</bookmark_value>
-- 
2.20.1
Comment 1 Buovjaga 2020-05-10 20:38:51 UTC
Thanks for the patch! However, it should be sent to gerrit:
https://wiki.documentfoundation.org/Development/gerrit
https://wiki.documentfoundation.org/Development/GetInvolved#License_statement

An easy way to edit directly inside gerrit:
https://wiki.documentfoundation.org/Documentation/GerritEditing