Hello!

I am trying to create a formula field for the following scenario

There is picklist type field name Anrede with values "Herr" and "Frau". This field is used for German Salutation. There is another picklist type field named Formal/Informal which has values like "Sie" and "du" 

Now I want to create a new formula based field where

If the Anrede field has value "Herr" and the Formal/Informal field has value "Sie" than the new field should show "Sehr geehrter Herr". Similarly If the Anrede field has value "Frau" and the Formal/Informal field has value "Sie" than the new field should show "Sehr geehrte Frau"

Alternatively 

If the Anrede field has value "Herr" and the Formal/Informal field has value "du" than the new field should show "Lieber". Also, If the Anrede field has value "Frau" and the Formal/Informal field has value "du" than the new field should show "Liebe"

Have been trying to solve this issue since long. Any suggestions are welcomed.