Solved: Re: Column with Multiple if conditions

gheecalipes25 · ‎11-23-2021

Hi,

Good Day!

I am trying to create a new column that will give me the results below. i tried using the nested ifs or the switch function but is not working. i might have been doing it wrong. below is the data i am working on.

if Regionname = Anz, India, Philippines Then "APAC"

if Regionname = Bulgaria, Denmark, France, Germany, Greece, Ivory Coast, Morocco, Netherlands, Poland, Portugal, Senegal, Serbia, Spain, UK Then "EMEA"

if Regionname =Canada, US Then "NA"

if Regionname = Colombia, Mexico, Nicaragua, Panama Then "LATAM"

if Regionname =At Home then "W@H"

else Regionname

Thank you so much for the feedback and solutions. 🙂

jppv20 · ‎11-23-2021

Hi @gheecalipes25 ,

Thy this formula:

Column=

IF(Regionname in {"Anz","India","Philippines"},"APAC",

IF(Regionname in {"Bulgaria","Denmark","France","Germany","Greece","Ivory Coast","Morocco","Netherlands","Poland","Portugal","Senegal","Serbia","Spain","UK"},"EMEA",

IF(Regionname in {"Canada","US"},"NA",

IF(Regionname in {"Colombia","Mexico","Nicaragua","Panama"},"LATAM",

IF(Regionname = "At Home","W@H",

Regionname)))))

If I answered your question, please mark it as a solution to help other members find it more quickly.

View solution in original post

AlexisOlson · ‎11-23-2021

I'd recommend a SWITCH.

Either like this:

Column =
SWITCH (
    TRUE (),
    Regionname IN { "Anz", "India", "Philippines" }, "APAC",
    Regionname
        IN {
        "Bulgaria",
        "Denmark",
        "France",
        "Germany",
        "Greece",
        "Ivory Coast",
        "Morocco",
        "Netherlands",
        "Poland",
        "Portugal",
        "Senegal",
        "Serbia",
        "Spain",
        "UK"
    }, "EMEA",
    Regionname IN { "Canada", "US" }, "NA",
    Regionname IN { "Colombia", "Mexico", "Nicaragua", "Panama" }, "LATAM",
    Regionname = "At Home", "W@H",
    Regionname
)

Or like this:

Column =
SWITCH (
    Regionname,
    "Anz", "APAC",
    "India", "APAC",
    "Philippines", "APAC",
    "Bulgaria", "EMEA",
    "Denmark", "EMEA",
    "France", "EMEA",
    "Germany", "EMEA",
    "Greece", "EMEA",
    "Ivory Coast", "EMEA",
    "Morocco", "EMEA",
    "Netherlands", "EMEA",
    "Poland", "EMEA",
    "Portugal", "EMEA",
    "Senegal", "EMEA",
    "Serbia", "EMEA",
    "Spain", "EMEA",
    "UK", "EMEA",
    "Canada", "NA",
    "US", "NA",
    "Colombia", "LATAM",
    "Mexico", "LATAM",
    "Nicaragua", "LATAM",
    "Panama", "LATAM",
    "At Home", "W@H",
    Regionname
)