Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 19, 2013 01:30 AM by Sharon59
Feb 15, 2013 06:43 AM|LINK
i had a formula that needed to insert into excel
xlRange.Formula = "=MIN(IF(C1:I1="Cash", D1:I1))";
it won't work due to in the output excel, it will just show the whole sentence instead of the result of the formula.
Feb 19, 2013 01:30 AM|LINK
I use a
C# Excel component to write formula like this:
sheet.Range["A1"].Formula = "MIN(IF(C1:I1="Cash", D1:I1))";
And get formula result in A1.
Please try to use xlRange.Formula="MIN(IFC1:I1="Cash",D1:I1))" instead of your original code.