[Libreoffice-bugs] [Bug 134211] Incorrect function name in the document of PV

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Nov 11 14:19:03 UTC 2020


https://bugs.documentfoundation.org/show_bug.cgi?id=134211

sdc.blanco at youmail.dk changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |mikekaganski at hotmail.com,
                   |                            |sdc.blanco at youmail.dk

--- Comment #2 from sdc.blanco at youmail.dk ---
@Mike -- can you help here.

I believe this bug report is about the PV function in Calc.

Here is Syntax (both in Function Wizard and relevant webpage) from: 
https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060103.html#pv

Syntax

PV(Rate; NPer; Pmt [; FV [; Type]])
Rate defines the interest rate per period.
NPer is the total number of periods (payment period).
Pmt is the regular payment made per period.
FV (optional) defines the future value remaining after the final installment
has been made.
Type (optional) denotes due date for payments. Type = 1 means due at the
beginning of a period and Type = 0 (default) means due at the end of the
period.

As I understand OP, Pmt is supposed to be wrong.

I also looked at the PMT function: 
https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060119.html#pmt

If you cannot see anything wrong with those functions, then maybe this should
be closed as INVALID or NOTABUG ?

cc: Mike Kaganski

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201111/22acbec9/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list