Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Nested IF Question?

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      ...
If statements
Nested IF
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    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's avatar
Samarth_18
Community Champion
4 years ago

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