> 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?
bloody hell, they seriously do that?
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.
(for unaware users, those are exchanged between Excel in English and in Swedish. In english CTRL-F for find, CTRL-B for bold. )