Replace Values in Power Query Based on Conditions

[Alicia83B]

I have an Opportunities Table with a column for Territory and Seller. I currently am replacing Mary’s territory from 1 to 16 using the below formula.

= Table.AddColumn(#"Changed Type1", "Chng Territory", each if [Assigned To] = "Mary" and [Territory] >=1 then "16" else [Territory])

However, I have two more sellers, Tim and Robin, that I need to add to the formula, but get an error message when I add “Mary” or “Tim” or “Robin” to my above formula.

Thank you in advance for taking a look at this and providing any help.

[Alicia83B]

Thank you @Vijay_A_Verma  for your help! 

[Vijay_A_Verma · Accepted solution]

Replace if condition with either of these (2nd one is useful if you have many names)

if ([Assigned To] = "Mary" or [Assigned To] = "Tim" or [Assigned To] = "Robin") and [Territory] >=1 then "16" else [Territory]

if List.Contains({"Mary","Tim","Robin"},[Assigned To]) and [Territory] >=1 then "16" else [Territory]