c# excel with formula that need ctrl+shift+enter RSS

• • Reply
  

  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.

  • Moved by Mikesdotnetting on Feb 15, 2013 05:42 PM
• • Reply
  

  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:

  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.
  
  

  Feet on Thorns.
  • Marked as answer by Young Yang - MSFT on Feb 28, 2013 11:46 AM