[Libreoffice-bugs] [Bug 131140] New: [PATCH] Add a negative number to the example of NPV.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131140

            Bug ID: 131140
           Summary: [PATCH] Add a negative number to the example of NPV.
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Documentation
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: hong at topbug.net
                CC: olivier.hallot at libreoffice.org

Created attachment 158399
  --> https://bugs.documentfoundation.org/attachment.cgi?id=158399&action=edit
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200305/60ab468b/attachment.htm>