I set formula for one cell like this:
cell.CellFormula = @"IFERROR((POWER(PRODUCT(IF(O3:O1000<>"""",1+O3:O1000,"""")),1/COUNT(O3:O1000))-1)*$I$1,"""")";
but when I open the Excel file, the formula is automatically added @ character:
=IFERROR((POWER(PRODUCT(IF(@O3:O1000<>"",1+@O3:O1000,"")),1/COUNT(O3:O1000))-1)*$I$1,"")
Could you please tell me how to solve this?
Thank you
