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: dev@poi.apache.org Reporter: fawaz.alhen...@ibm.com 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: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org