source/text/scalc/01/04060118.xhp | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-)
New commits: commit fff403a7563b89242444d18b510baf7ebfa7809f Author: Olivier Hallot <[email protected]> AuthorDate: Mon Sep 21 08:05:16 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Mon Sep 21 13:26:41 2026 +0200 tdf#173408 Fix example for NPER. Add a warning on the result consistency. Change-Id: I3fe8eb82a9eda129ea21777dc7746090be70e118 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/211286 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/01/04060118.xhp b/source/text/scalc/01/04060118.xhp index a50a007e48..f804099db0 100644 --- a/source/text/scalc/01/04060118.xhp +++ b/source/text/scalc/01/04060118.xhp @@ -589,8 +589,9 @@ <paragraph id="par_id3145127" role="paragraph"><emph>Type</emph> (optional) is the due date of the payment at the beginning or at the end of the period.</paragraph> <embed href="text/scalc/01/common_func.xhp#optional_args"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3147378" role="paragraph">How many payment periods does a payment period cover with a periodic interest rate of 6%, a periodic payment of 153.75 currency units and a present cash value of 2.600 currency units.</paragraph> -<paragraph id="par_id3156171" role="paragraph"><input>=NPER(6%;153.75;2600)</input> = -12,02. The payment period covers 12.02 periods.</paragraph> +<paragraph id="par_id3147378" role="paragraph">How many payment periods does a payment period cover with a periodic interest rate of 5%, a periodic payment of -153.75 currency units and a present cash value of 2.600 currency units.</paragraph> +<paragraph id="par_id3156171" role="paragraph"><input>=NPER(5%;-153.75;2600)</input> = 38.28. The payment period covers 38.28 periods.</paragraph> +<note id="par_id61789988420156">Users are advised to interpret NPER negative results or #NUM! error, as it may be the result of an inconsistent or meaningless set of arguments.</note> </section> </sort> <paragraph id="par_id3150309" role="paragraph"><link href="text/scalc/01/04060103.xhp">Back to Financial Functions Part One</link></paragraph>
