source/text/scalc/01/04060118.xhp | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-)
New commits: commit d811050d9789f52c01962a67ad210517aa64db3a Author: Olivier Hallot <[email protected]> AuthorDate: Mon Sep 21 08:23:55 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Mon Sep 21 13:39:11 2026 +0200 tdf#173409 Fix example for FV function Add warning on inconsistent set of arguments Change-Id: I968a50362bbbe026a16f0969b02f731f5c87ade2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/211288 Reviewed-by: Olivier Hallot <[email protected]> Tested-by: Jenkins diff --git a/source/text/scalc/01/04060118.xhp b/source/text/scalc/01/04060118.xhp index f804099db0..24cb5d5dbf 100644 --- a/source/text/scalc/01/04060118.xhp +++ b/source/text/scalc/01/04060118.xhp @@ -541,8 +541,9 @@ <paragraph id="par_id3150999" role="paragraph"><emph>Type</emph> (optional) defines whether the payment is due at the beginning or the end of a period.</paragraph> <embed href="text/scalc/01/common_func.xhp#optional_args"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3146813" role="paragraph">What is the value at the end of an investment if the interest rate is 4% and the payment period is two years, with a periodic payment of 750 currency units. The investment has a present value of 2,500 currency units.</paragraph> -<paragraph id="par_id3149302" role="paragraph"><input>=FV(4%;2;750;2500)</input> = -4234.00 currency units. The value at the end of the investment is 4234.00 currency units.</paragraph> +<paragraph id="par_id3146813" role="paragraph">What is the value at the end of an investment if the interest rate is 3% and the payment period is 18 years, with a periodic payment of -1200 currency units and no investment value. </paragraph> +<paragraph id="par_id3149302" role="paragraph"><input>=FV(3%;18;-1200;0)</input> = 28,097.32 currency units. The value at the end of the investment is 28,097.32 currency units.</paragraph> +<note id="par_id941789988924212">Users are advised to interpret FV negative results or #NUM! error, as it may be the result of an inconsistent or meaningless set of arguments.</note> </section> <section id="fvschedule">
