Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Formula for nested ifs condition

Hi,   Would like to seek your help on the below.    if Priority = 2 hours, then Pass, if not 2 hours, then failed,  if Priority = 4 hours, then Pass, if not 4 hours, then failed     Thank you...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • PabloDeheza's avatar
    PabloDeheza
    3 years ago

    Try this:

    IF (
    priority = "p1",
    IF (
        duration <= 2,
        "Pass",
        "Fail"
    ),
    IF (
        priority = "p2",
        IF (
            duration <= 4,
            "Pass",
            "Fail"
        ),
        BLANK ()
    )
)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

hi, in bo the formula should be:

 

if (priority = p1, then (if duration <= 2,  "pass", "fail") elseif (priority=p2, then (if duration >=4, "pass", "fail")

else "null"

PabloDeheza's avatar
PabloDeheza
Solution Sage
3 years ago

Try this:

IF (
    priority = "p1",
    IF (
        duration <= 2,
        "Pass",
        "Fail"
    ),
    IF (
        priority = "p2",
        IF (
            duration <= 4,
            "Pass",
            "Fail"
        ),
        BLANK ()
    )
)