https://bugs.documentfoundation.org/show_bug.cgi?id=120887
Bug ID: 120887
Summary: PV function returns wrong answer
Product: LibreOffice
Version: 6.0.0.2 rc
Hardware: x86-64 (AMD64)
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Unless I am misunderstanding something, the Present Value (PV) function returns
wildly wrong answers.
This: PV(0.25,180,626.4,0,0)
gives the answer -$2,505.60
I checked an online calculator and it returned $90,706.15
Steps to Reproduce:
1. Enter the formula =PV(0.25,180,626.4,0,0)
2.
3.
Actual Results:
-$2,505.60
Expected Results:
Something close to $90,706.15 (perhaps with a minus sign)
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Mac OS X (All)
OS is 64bit: no
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
