[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

            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
which is identical to Microsoft Excel
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]