Hi,
I’m facing an issue while trying to print output cell from the spreadsheet and its keep on showing value as #DIV/0!. But when I trying to open the spreadsheet manually and inspect the cell actual value as 0.920. Please find the below formula and cell details. Also I have attached the spreadsheet.
Sheet Name : FL_Calc
Cell No: D143
Formula : =IF(D$1="","",SUMPRODUCT(–(INDIRECT("‘Individual Census’!$B$7:$B$"&count+6)=D$1),–(INDIRECT("‘Claim Cost’!$FA$7:$FA$"&count+6)),–(INDIRECT("‘Claim Cost’!$FX$7:$FX$"&count+6)))/(D$62/D$61))
Aspose Version : 17.1.4