That sounds correct. This issue would be when the decimal separator matches the argument separator. In that situation =IF(A1 > 42.1, B1, C1) would be equivalent to =IF(A1 > 42,1; B1; C1)

The possibility of incorrect parsing of equation with a variadic function that contains a decimal number in the equation.

However, this is a localization as even the functions change names.

https://www.reddit.com/r/excel/comments/1flsvyu/separator_co...

    It’s just a locale setting as to which is applied. If you use English (US or UK) then your argument separator will be a comma. If you use other languages, then a semi colon will apply. You’ll find most guidance online referring to English language functions and comma separators, but ultimately it doesn’t really matter. If you ship a spreadsheet to me that you wrote in German functions and syntax that contains:

    =SVERWEIS(X2;A:C;3;0)
    I’ll open that and find

    =VLOOKUP(X2,A:C,3,0)