Hello @fuglyjowls About the challenge with the error
#NAME ?. Have you tried double-checking that both the formula and the Calc configuration use the same language?
I’m asking this because one possible cause of this
#NAME ? error is that you try to use a formula in a language that does not match the present language configuration of Calc. If so, to resolve this challenge, choose one of the following two options:
- Option 1: Adapt your formula. So that
it is in a language that match the
present language use by Calc.
- Option 2: Change the language of your Calc. So that it match the language use by the formula. Each time you change the language, you might need to restart your Calc.
Below is the same answer as above. But with details & examples if you’re interested in those.
To find which language your LibreOffice Calc is presently using, navigate to “Tools > Options” Then search for the various language configurations. With focus on the configuration(s) which affect the language use by the formulas.
- If your LibreOffice Calc is presently configured to use the French language. Then you need to write the formula in French.
- If your LibreOffice Calc is presently configured to use the English language. Then you need to write the formula in English.
Here is a formula example in French
=MOYENNE(A1:A2) Documentation at Fonctions statistiques - Quatrième partie
Here is the same formula example in English
=AVERAGE(A1:A2). Notice that the spelling is different. But the end result is the same. Documentation at Statistical Functions Part Four
Steps to reproduce this
#NAME ? error:
- Using Calc, navigate to “Tools > Options”. Configure your Calc to use the French language
- Try to use this English formula
- Calc will display this
#NAME ? error. Because presently Calc does not understand English. Only French.
- Now to resolve this challenge, replace the formula
=MOYENNE(A1:A2). Where “MOYENNE” means “AVERAGE” in French.
- The error is resolve. The formula works.