Excel IF statement results in error: Exception from HRESULT: 0x800A03EC

Question

I am creating an excel report in C#. When I add a formula like below, everything works fine:

totalCellFormulaRange.Formula = "=SUM(AH7:AS7)"; //totalCellFormulaRange is a Range object from Microsoft.Office.Interop.Excel

But now when I try to add a formula consisting of an if statement like below,

memberGuidesCellFormaulaRange.Formula = "=IF(LEFT(D7;12)=\"Welcome Pack\";O7*$AQ$4;0)";

then I get this error:

Exception from HRESULT: 0x800A03EC

The above if statement works 100% if typed out in a Excel sheet. It only fails in C# and the exception is thrown right when it hits this line of code.

@BugFinder regional settings force some of us to do that, when the comma is your decimal separator. — rene, Oct 19 '17 at 14:08
@BugFinder The Excel syntax for it statement on my side is "=IF(logical_test;value_if_true;value_if_false)" — Tumelo, Oct 19 '17 at 14:20
is it any better with using @"=IF(LEFT(D7;12)=""Welcome Pack"";O7*$AQ$4;0)" - failing that are you doing a lot of excel setting at one time? — BugFinder, Oct 19 '17 at 14:27
@BugFinder You were actually correct. When I tried it with the comma it worked :) — Tumelo, Oct 19 '17 at 14:41

score 4 · Accepted Answer · edited Oct 24 '17 at 06:10

4

Although localization for excel allows for ";" use in place of commas, the COM interface doesn't register the ";" and a comma should be used instead.

memberGuidesCellFormaulaRange.Formula = "=IF(LEFT(D7,12)=\"Welcome Pack\",O7*$AQ$4,0)";

For more information about localization problems, and some general pointers when writing interop code for Excel, see this SO Q&A.

edited Oct 24 '17 at 06:10

Shaun Wilson

8,727
3
50
48

answered Oct 19 '17 at 14:28

Jay Wilson

66
5

I removed the semi-colons and used the commas instead and it works now – Tumelo Oct 19 '17 at 14:42

Excel IF statement results in error: Exception from HRESULT: 0x800A03EC

1 Answers1