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:
=IF($B$8>0,(100*(SUMIF($CH15:$CH1000,1,$D15:$D1000)/$B$8)),0)
Both the IF and the SUMIF are supported. Why can't it calculate this formula?
Thanks.