I am using the Workbook.CalculateFormula() method. It is throwing this exception:
Unsupported function in formula calculation engine - code 83. Error in calculating cell D8 in Worksheet xxx.
The formula in D8 is as follows:
Both the IF and the SUMIF are supported. Why can't it calculate this formula?