Conditional Column with multiple IFs and Else against multiple columns

[Hpaul]

Hi I am trying to create a conditional column with multiple possible results. I keep getting "Token Comma Expected" I go to Custom Column , and add this:

if [Dependents] >0 and Text.Contains([Applicant Name] "&" ) then "Family"
else if [Dependents] =0 and Text.Contains([Applicant Name] "&" ) then "Couple"
Else "Single"

Any help is much appreciated!! I suspect the answer is simple and I am losing my hair over it.

[Greg_Deckler · Accepted solution]

I believe you want this:

if [Dependents] >0 and Text.Contains([Applicant Name], "&" ) then "Family"
else if [Dependents] =0 and Text.Contains([Applicant Name], "&" ) then "Couple"
Else "Single"