All Questions
Tagged with irr apache-poi
2 questions
2
votes
1
answer
1k
views
IRR in poi return NaN but correct value in excel
When i calculate Irr value use apache/poi i get Double.NaN, but the same inputs in excel i got a negative value.
So why they return different value?
inputs here:
irr(-1.0601017230994111E8,19150.63,...
- 63
0
votes
0
answers
158
views
How to get formula value from workbook cell without using apache poi
I am applying IRR formula in workbook using apache poi and able to see the value in excel sheet. But am getting the value as #NUM! when I tried to retrieve the value using FormulaEvaluator.
Example
...
