Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 19, 2013 01:30 AM by Sharon59
Member
15 Points
36 Posts
Feb 15, 2013 06:43 AM|LINK
Hi,
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.
180 Points
31 Posts
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.
waterduck
Member
15 Points
36 Posts
c# excel with formula that need ctrl+shift+enter
Feb 15, 2013 06:43 AM|LINK
Hi,
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.
Sharon59
Member
180 Points
31 Posts
Re: c# excel with formula that need ctrl+shift+enter
Feb 19, 2013 01:30 AM|LINK
I use a C# Excel component to write formula like this:
And get formula result in A1.
Please try to use xlRange.Formula="MIN(IFC1:I1="Cash",D1:I1))" instead of your original code.