| Summary: | [PATCH] Add a negative number to the example of NPV. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Hong Xu <hong> |
| Component: | Documentation | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | ||
| Severity: | normal | CC: | hong, ilmari.lauhakangas, olivier.hallot |
| Priority: | medium | ||
| Version: | unspecified | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | patch | ||
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 |
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