Topic: How to use Excel formulas found on the Web in German/French/Spanish versions of Excel  (Read 9191 times)

We have found an Excel formula on the Internet that we would like to use in an .xlsx (or e. g. .csv) file, exported from ConfTool. Unfortunately, this formula does not work although it is mentioned in several sources on the internet. What is the reason for this and what can be done?

When using formulas found on the Internet for Excel, you should pay attention to which localized version of Excel they were created for.

When opening a foreign language ".xlsx" file, Excel usually has no problems and automatically translates the formulas into the respective language of the target application.

However, if you find a formula on the Internet that you want to use, it cannot be typed or copied directly into Excel if your Excel version does not use the same localization.

Furthermore, it has to be considered if full stops or commas are used as decimal separator: If comma is used as decimal separator (as in German numbers) the comma used to separate parameters in Excel formulas must be replaced by a semicolon.

You do not need to do the conversion between Excel localizations manually; Microsoft offers an Excel Add-In called Excel Functions Translator, which is available free of charge in the Microsoft Store. You only need to copy and paste the formula you want to translate, knowing which is the source language. By setting the desired target language and some parameters, the Excel Functions Translator will convert the formula into the desired target language (see Images 1-3).

You can find detailed installation instructions for the Excel Functions Translator here:
https://support.office.com/en-us/article/excel-functions-translator-f262d0c0-991c-485b-89b6-32cc8d326889
If you do not want to install this add-in, you can also translate the desired formulas directly on the following website:
https://en.excel-translator.de/translator/
This site is not provided by Microsoft.