Dfyjkt

I have a dataset that looks like the following:

A B C
1 10 145
1.1 11 0
1.2 12 0
1.3 13 0
2 14 145
2.1 15 0
2.2 16 0
3 17 145
3.1 18 0
3.2 19 0

Columns A and B in the table are my input data, column C is created with the following formula:

=IF(MOD([@A],1)=0,SUM([B]),0)

This is a simplified example and not the actual formula I am using, but it suffices as a minimal reproducible example.

When I enter this formula manually into the edit bar it works exactly as expected and produces the values in the table above. However, when I try to input this formula into the cells using VBA it fails. It gives me an error:

Error: invalid name

If I then click the cell and into the edit bar as if I wanted to manipulate the formula manually and just immediately hit enter, without actually changing anything in the formula, the error vanishes and the results get correctly displayed once more as before.

The code I use to enter the formula into the cell via VBA is the following:

Sub InputFormula()
 Set srcTable = ActiveSheet.ListObjects(1)
 fmtString = "=IF(MOD([@A],1)=0,SUM([B]),0)"
 Range(srcTable.Name & "[C]").Formula = fmtString
End Sub

Why is the obviously correct formula broken when applied through VBA and how can I correct it so that application through VBA works?

I am using Excel 2019 on Windows 10 x64.

I figured out the solution to my problem:

I am using a non-English version of Excel. When I try to use the localized function names in VBA it comes up with an error as described in the question. When I use the corresponding English names though, everything works as expected.

This is counterintuitive, because when I apply conditional formatting through VBA I have to use the localized function names. Using the English ones there does not work.