[Bug 64137] New: IRR NaN When it should give back a value

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[Bug 64137] New: IRR NaN When it should give back a value

Bugzilla from bugzilla@apache.org
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: [hidden email]
          Reporter: [hidden email]
  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: [hidden email]
For additional commands, e-mail: [hidden email]