https://bugs.documentfoundation.org/show_bug.cgi?id=100646
Bug ID: 100646
Summary: FV function, PayType parameter
Product: LibreOffice
Version: 5.3.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: r...@post.cz
ODF specification
6.12.20 FV
Summary: Compute the future value (FV) of an investment.
Syntax: FV( Number Rate ; Number Nper ; Number Payment [ ; [ Number Pv = 0 ]
[ ; Number PayType = 0 ] ] )
... PayType: the type of payment, defaults to 0. It is 0 if payments are due
at the end of the period; 1 if they are due at the beginning of the period.
=FV(0,0525/1; 10*1; -100; -6500; 2) return result 12 182,00 , should
return #error. Last parameter is 2, only 0 or 1 is allowed.
=FV(0,0525/1; 10*1; -100; -6500; -2) return result 12 115,19
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs