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
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
(In reply to Hong Xu from comment #0) > +<item type="input">=NPV(8.75%;10;20;30;-5)</item> = 45.68 it's actually 45.86 ! ;)
Pierre F committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/8b4da8e88b89d877bf4a0c6c2d047c992fc26476 NPV() example. tdf#131140