Hi,
I have an Excel workbook that uses the NPER function but it causes a #DIV/0! division by zero error in Microsoft Excel.
Here is an example workbook: TestCase08.zip (6.6 KB)
However, if I use Apose.Cells .NET versi…...CalculateFormula(); // Calculate formula. string s2 = worksheet.Cells["A3"]...IsError; Value : #DIV/0!; Formula=NPER(C3/12,D3,-E3,0,0) ] The...