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

that worked. thank you very much. 🙂