4 ms·
> If you use a non-English version of Excel you cannot use "if" but rather have to use whatever the word for if is in that language (for example "wenn" in Germa
by _a_a_a_ 3y ago
> If you use a non-English version of Excel you cannot use "if" but rather have to use whatever the word for if is in that language (for example "wenn" in German)
bloody hell, they seriously do that?
- zyberzero 3y agoYes. And the keyboard bindings are also localized, so in Excel in Swedish on would press CTRL-F to make the text bold (F is for "fetstil") and to find one would press CTRL-B, logically for "sök". (for unaware users, those are exchanged between Excel in English and in Swedish. In english CTRL-F for find, CTRL-B for bold. )
- fho 3y agoOr (as I just had the pleasure to find out) CTRL-SHIFT-F on my new work machine : - \
- Lockal 3y agoNot 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.
- bjornasm 3y agoYes. Every last word/command. Its extremely annoying.