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!