Software

Ask something
Discussion Locked

Non-english excel formula

0 helpful
5 replies

by divermo

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Where can I find translations for Excel functions into foreign languages (e.g. Dutch, French, ...)

5 replies

by c:\\>

Excel formulas are like key words in a programming language, you cannot translate them. You have to use the proper syntax in order for them to work. You can use a book in those languages, to understand them, but you can't touch the syntax.

by divermo

Sure I have to use the proper syntax : e.g. in the dutch version I have to use som(...) or afronden(...) in stead of sum(...) or round(...). However it's not always obvious to look for the dutch syntax for Excel-tips given in TechRepublic : is therereally no list?

by estebandelatorre

Yes, that's a common issue which I 've fighted for some time. This is the answer: Make all your formulas in english, therefor every excel in another idion will run the macro without any problem.
If you have a german formula and want to make it workin spanish and don't know how to type it, the correct answer is translate it into english, it will work on an spanish excel or s.o.

This discussion is closed to new replies.