Column with Multiple if conditions

[gheecalipes25]

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 · Accepted solution]

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.

[AlexisOlson · Accepted solution]

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
)

[jppv20 · Accepted solution]

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.

[gheecalipes25]

Thank you.. it worked. 🙂