Enable english formulas in Excel with any other predefined language
I have been teaching Excel and it would make it a lot easier if same formulas and functions would work in everyones computers regardless of the language they have chosen for their own excel. The translations cannot be guessed, so at least there need to be translations available, e.g. in these web pages. So, that I could search for example for "VLOOKUP" and I could get it in any language I want.
It could be preference where you could choose whether you want to write the formulas in your predefined language or in english.
Simply disassociating the OS language, the UI language and the formula language. This affects all international users, and that's quite a few.
Options for implementation that could satisfy me may include:
1. A preference setting that requires Excel to be restarted to be used, selecting formula language or simply a toggle between UI language and english.
2. A temporary button to be pressed on the Formula ruler bar with same options as above
3. a function within which all functions are in English. =@ENGL(VLOOKUP(......
Although this last one may create complexities for the auto complete feature.
Sure, this might only affect a small number of people. But this is so incredibly infuriating.