if statement with between conditions

Hi Anonymous ,

Test the below:

DurationFilter =
IF (
    INCIDENT_FACT[DURATION_HOURS] <= 0.5,
    "Less Than 30 Mins",
    IF (
        INCIDENT_FACT[DURATION_HOURS] > 0.5
            && INCIDENT_FACT[DURATION_HOURS] <= 0.75,
        "Past 30 Mins",
        IF (
            INCIDENT_FACT[DURATION_HOURS] > 0.75
                && INCIDENT_FACT[DURATION_HOURS] < 1,
            "Past 45 Mins",
            IF (
                INCIDENT_FACT[DURATION_HOURS] >= 1
                    && INCIDENT_FACT[DURATION_HOURS] < 1.5,
                "Past 1 Hr",
                IF (
                    INCIDENT_FACT[DURATION_HOURS] >= 1.5
                        && INCIDENT_FACT[DURATION_HOURS] <= 2,
                    "Past 1Hr 30Mins",
                    IF (
                        INCIDENT_FACT[DURATION_HOURS] > 2
                            && INCIDENT_FACT[DURATION_HOURS] < 2.5,
                        "Past 2 Hr",
                        IF (
                            INCIDENT_FACT[DURATION_HOURS] >= 2.5
                                && INCIDENT_FACT[DURATION_HOURS] <= 3,
                            "Past 2Hr 30Mins",
                            IF (
                                INCIDENT_FACT[DURATION_HOURS] > 3
                                    && INCIDENT_FACT[DURATION_HOURS] < 3.5,
                                "Past 3 Hr",
                                IF (
                                    INCIDENT_FACT[DURATION_HOURS] >= 3.5
                                        && INCIDENT_FACT[DURATION_HOURS] <= 4,
                                    "Past 3Hr 30Mins",
                                    IF ( INCIDENT_FACT[DURATION_HOURS] > 4, "Past 3 Hr", BLANK () )
                                )
                            )
                        )
                    )
                )
            )
        )
    )
)

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien