Nested IF Question?

[Anonymous]

Hello All, I need some assistance with writing Nested If statement, I am trying to create a new column with the following if statement.

IF      [Category] = "Martial Arts "         THEN

IF          [Sub Category] = "Boxing"                        THEN "Boxing "

                ELSEIF  [Sub Category] = "Karate"                        THEN "Karate"

    END

ELSEIF  [Category] = "Sports"                              THEN "Sports"

ELSEIF  [Category] = "Winter Sports"        THEN

    IF          [Sub Category] = "Snowboarding"              THEN "Snowboarding"

    ELSEIF      [Sub Category] = "Skiing"            THEN "Skiing"

    END

I tried using Switch function and had no luck, does anyone has any suggestions?

Thank you

[AlexisOlson · Accepted solution]

I think SWITCH is a good idea.

SWITCH (
    TRUE (),
    [Category] = "Martial Arts " && [Sub Category] = "Boxing", "Boxing",
    [Category] = "Martial Arts " && [Sub Category] = "Karate", "Karate",
    [Category] = "Sports", "Sports",
    [Category] = "Winter Sports" && [Sub Category] = "Snowboarding", "Snowboarding",
    [Category] = "Winter Sports" && [Sub Category] = "Skiing", "Skiing"
)

[Samarth_18]

Hi @Anonymous ,

You can use below code:-

Measure =
IF (
    [Category] = "Martial Arts ",
    IF (
        [Sub Category] = "Boxing",
        "Boxing",
        IF (
            [Sub Category] = "Karate",
            "Karate",
            IF (
                [Category] = "Sports",
                "Sports",
                IF (
                    [Category] = "Winter Sports",
                    IF (
                        [Sub Category] = "Snowboarding",
                        "Snowboarding",
                        IF ( [Sub Category] = "Skiing", "Skiing" )
                    )
                )
            )
        )
    )
)

Thanks,

Samarth