Hi there,
i`m searching this site every time i have to create a complexer formula. So this time, i thought, i put it in my blog as a reminder 
http://msdn.microsoft.com/en-us/library/bb862071.aspx
A thing, you should have a look at, is the language dependant syntax in the formulas, f.e. on a german SP Server you have to use the “;” semicolon as a seperator in your formula, but on an english server a comma “,”. This is not mentioned in the msdn.
If you think of I18N and Solution Deployment, this is really a thing, microsoft should standardize.
Yes, but if you are doing the expression programmatically, how do you figure out what is the correct seperator to be used?
THis is a good one The one thing i have not been able to figure out is what seperator do you use if the formula is programmatically created and it could be used on any site and the default language is not english?
This is a question, i can`t actually answer in generally. If you set the formula programmatically, you can test the installed language and concatenate the formular dynammically at runtime. For an english site the separator would be the comma “,”. For a german site you have to take the semicolon “;”. I don´t actually know the seperators in other languages. Maybe i will ask microsoft and list the result here.