How can I have multiple IF arguments with Multiple True values in the same column.

Question

How can I have multiple IF arguments with Multiple True values in the same column. I have several communities in the same city and several in other cities. I want a formula that looks at the community name and decides what city should fill the cell. =IF(C27="Boykin Hills" OR "Collins Cove" OR "Night Harbor","Chapin")))(C27="Bradford Meadows" OR "Canopy of Oaks" OR "Jackson Preserve" OR "South Bridge" Or "Stillpointe" OR "The Cove","Sumter"))) The first part of the formula works. When I tried to add another argument for a new city it stopped working

Answer 1

Change the formula to

=IFS(OR(C27={"Boykin Hills", "Collins Cove", "Night Harbor"})," Chapin", OR(C27={"Bradford Meadows","Canopy of Oaks", "Jackson Preserve", "South Bridge", "Stillpointe", "The Cove"}), "Sumter", TRUE, "")