[Libreoffice-bugs] [Bug 130823] LibreOffice CALC TBILLYIELD function returns incorrect interest rate (Too low).
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sat Sep 5 15:15:51 UTC 2020
https://bugs.documentfoundation.org/show_bug.cgi?id=130823
--- Comment #8 from edwardk at vivaldi.net ---
Dear Sirs,
I have provided ALL info necessary to reproduce this bug in the original
submission. The function
TBILLYIELD functions return incorrect interest rate.
Using the following inputs:
TBILLYIELD(Settlement; Maturity; Price)
(02/25/20, 03/24/20, 99.8775) returns .014718 SHOULD RETURN .01577
as verified with MS EXCEL
COMPARE THE RESULT OF CALC TBILLYIELD WITH THE MICROSOFT OFFICE EXCEL VERSION!
SEE COMMENT BELOW THE RESULT .014718 IS INCORRECT! This should be a simple fix!
--
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/20200905/7e353c28/attachment.htm>
More information about the Libreoffice-bugs
mailing list