Bug 64137 - IRR NaN When it should give back a value
Summary: IRR NaN When it should give back a value
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: unspecified
Hardware: All All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-02-11 21:30 UTC by Fawaz Alhenaki
Modified: 2020-02-11 21:30 UTC (History)
0 users


Attachments
Reproduction file (983 bytes, text/plain)
2020-02-11 21:30 UTC, Fawaz Alhenaki 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Fawaz Alhenaki 2020-02-11 21:30:15 UTC 
Created attachment 37012 [details]
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).