3 ms·
Not just that, it also requires "native" decimal separator. For example, if you installed English Excel on system with Russian calendar/numbers/currency, the f
by Lockal 3y ago
Not just that, it also requires "native" decimal separator.
For example, if you installed English Excel on system with Russian calendar/numbers/currency, the formula can look like: =COUNTIF(B2:B6;">1,5") (syntax error otherwise).
English Excel in English environment: =COUNTIF(B2:B6;">1.5")
Russian Excel in Russian environment: =СЧЁТЕСЛИ(B2:B6;">1,5")
What will happen when you enter 1.5 into English Excel? Everyone knows it is 01.май. What happens if you enter 100.5? It is a string, Excel on this machine expects different separator.
- xattt 3y agoIf they were fully committed, they should have turned the quotes into double angle quotation marks.
- berkes 3y agoAnd with Dutch (in Google Sheets), the argument separators differ too. =IF(B2,42,1337), in Dutch, =ALS(B2;42;1337) or, when using english formulas, still is =IF(B2;42;1337). Terrible when you copy formulas around.