Mart Muller's Weblog

Using formula's in non-Engligh SharePoint versions can be a real pain. The functions used are translated so they are 'understandable' by the users. In Dutch, for example, functions like ‘IF’ or ‘Today’ should be translated to ‘ALS’ or ‘Vandaag’. Some examples:

• English: =IF(AND([Column 1]>[Column 2];[Column 1]<[Column 3]);"OK";"Not OK")
• Dutch: =ALS(EN([Kolom 1]>[Kolom 2];[Kolom 1]<[Kolom 3]);"OK";"Niet OK")
• German: =WENN(UND([Spalte 1]>[Spalte 2];[Spalte 1]<[Spalte 3]);"OK";"Nicht OK")

Documentation is quite hard to find, but available on the Office sites in your language. Before you spend hours on trail and error, check out these examples:

• Dutch: http://office.microsoft.com/nl-nl/sharepointserver/HA101054791043.aspx?pid=CH101760291043#2
• German: http://office.microsoft.com/de-de/sharepointserver/HA101054791031.aspx?pid=CH101760291031

For other languages, take a deep search in the Office online site.