You can set formula like this in an excel file using c#:
Worksheets("Sheet1").Range("A1").Formula = "=$A$4+$A$10";
If the formula contains '%' then an error occurs!!! (a table column name contains %) How can you use % in formula?
Worksheets("Sheet1").Range("A1").Formula = "=$A$4+$A$10";
If the formula contains '%' then an error occurs!!! (a table column name contains %) How can you use % in formula?