How to combine IF and Text formulas in Sharepoint Syntax?

Hello @all!

Basically, I want to create a personal salutation based on columns in my sharepoint contact list. The logic is, that if the salutation code is female (“w”), I want it to start with “Dear Mrs.”, if it’s male (“m”) with “Dear Mr.” and if it’s an Organization with “Dear Sir or Madam”. Then, I want to concatenate this part with the job title and the name.

I created a calculated column wit the following formula: (all in German, but same logic)

=WENN([Begrüßungscode]=w; “Sehr geehrte”&” “&[Anrede]&” “[Titel]&” “&”[Name]”,”) OR ([Begrüßungscode]=m; “Sehr geehrter”&” “&[Anrede]&” “[Titel]&” “&”[Name]”,”) OR ([Begrüßungscode]=Organisation; “Sehr geehrte Damen und Herren,”, “not OK”)

Could you help me to find out, whats wrong with this syntax? 

I’m happy for any clue to the right direction 😀

Thanks!