https://bz.apache.org/bugzilla/show_bug.cgi?id=64137
Bug ID: 64137
Summary: IRR NaN When it should give back a value
Product: POI
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 37012
--> https://bz.apache.org/bugzilla/attachment.cgi?id=37012&action=edit
Reproduction file
I have created a sample of when the issue occurs. IRR in apache documentation
says that covers "20 tries" as shown here
https://poi.apache.org/apidocs/dev/org/apache/poi/ss/formula/functions/Irr.htmlÂ
which is identical to Microsoft Excel
https://support.office.com/en-us/article/irr-function-64925eaa-9988-495b-b290-3ad0c163c1bc
This indicate that the result is the same between the two; however, in the case
of apache poi, it seems that the result is returned as NaN (while excel returns
the actual result).
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
