If statement with IfContains

[akshaya2595]

I am trying to write a formula statement with the following condition:

If Func = "D" AND FuncType Contains "M" OR FuncType Contains"L" Then "Da"

else if Func = "P" AND FuncType Contains "Pr" OR FuncType Contains "Se" Then "Pro"

Else "Others"

What is the write syntax to write this statement?

Thank you!!

[Felipe_Ribeir0]

Hi @akshaya2595 

Use this one:

If Func = "D" AND (Contains([FuncType], "M") OR CONTAINS([FuncType], "L")) Then "Da"
elseif Func = "P" AND (Contains([FuncType], "Pr") OR Contains ([FuncType], "Se")) Then "Pro"
Else "Others"
ENDIF

[binuacs]

@akshaya2595 One way of doing this

If [Func] = "D" AND (Contains([FuncType],"M") OR Contains([FuncType],"L")) Then "Da"
ElseIF ([Func] = "P" AND (Contains([FuncType],"Pr") OR Contains([FuncType],"Se")) Then "Pro"
Else "Others"
EndIf

[Felipe_Ribeir0]

Hi @akshaya2595 

It worked?