<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - [PATCH] Add a negative number to the example of NPV."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131140">131140</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>[PATCH] Add a negative number to the example of NPV.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Documentation
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>hong@topbug.net
</td>
</tr>
<tr>
<th>CC</th>
<td>olivier.hallot@libreoffice.org
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=158399" name="attach_158399" title="patch">attachment 158399</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=158399&action=edit" title="patch">[details]</a></span>
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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>