Hi,
I have an example worksheet with the following formula at cell A1:
=FV(0.05/12,NPER($A$2/12,$B$2,-$C$2-IF(FALSE,$C$2,0),0,0),0,-400000,0)
The NPER(…) part evaluates to #NUM! in Excel, resulting in the entire formula evaluating to #NUM!.
However, in Aspose.Cells version 18.6.0, the entire formula evaluates to 0. Can you please have a look.
You can try this code.
var workbook = new Workbook(@"C:\Test.xlsx");
workbook.CalculateFormula();
var sheet = workbook.Worksheets[0];
Cell cell = sheet.Cells["A1"];
var value = cell.ToString();
// value is "Aspose.Cells.Cell [ A1; ValueType : IsNumeric; Value : 0; Formula:=FV(0.05/12,NPER($A$2/12,$B$2,-$C$2-IF(FALSE,$C$2,0),0,0),0,-400000,0) ]"
// But in Excel, it is #NUM!.
Thanks!
Test.zip (6.1 KB)