Free Support Forum - aspose.com

Aspose.cells On IRR calculation

Hello,

I’m using it Aspose.cells When IRR is used to calculate internal rate of return, it is found that there is a group of data that can be correctly calculated in excel2016, while it is ‘ #num!’ In Aspose. The data are as follows:
{- 211030557.3, - 266410271.8, - 266410271.8, - 34492567.96, - 1270314.464, - 1270314.464, - 56719475.58, - 11332216.14, - 14568665.599905653.28868511395.7490404807.71, 113434356.8,51264503.08,103961533.6,96827882.3,129465580.8,133449059.7,125152736.7,111266043,99157574.89,68453297.87,9291641.541,-2360636.855,-13401423.3,-23749074.52,-9054058.407,-10142058.66,-36137352.56,-9380853.492,-2449708.353,-2449708.353,-372976.4904,-372976.4904,-372976.4904,29888566.46,8297305.825,48506652.65,33500101.57,18680354.04, 11208212.42,7409873.768,0,0,0,0,0,0,-22540262.57,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0};

Later, some tests were conducted, and it was found that more data can be calculated normally in excel2016, but the calculation results cannot be obtained in Aspose. The test data are as follows:

{-1204,-674,-147,40,547,26,1499,550,-858,-754,-975}

{998,-486,-572,-8,765,-794,1033,392,91,-615,804}

{957,-609,-418,413,855,-865,1249,-454,719,-901,946}

The results in Aspose are inconsistent with those in Excel, so we can’t get customers’ approval. We hope we can get help. Thank you!

@ivanhu2013,
Please check our reply here and let us know your feedback.

@ivanhu2013,

Please try our latest version/fix: Aspose.Cells for .NET v20.9.7 (attached)
Aspose.Cells20.9.7 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.9.7 For .Net4.0.Zip (5.4 MB)
Aspose.Cells20.9.7 For .NetStandard20.Zip (5.4 MB)

Your issue should be fixed in it.

Let us know your feedback.