Formula for nested ifs condition

[Anonymous]

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 so much for your answers. God Bless You

[Anonymous]

how about if priority and duration are on a different table?

[Anonymous]

that worked. thank you very much. 🙂

[PabloDeheza]

Hi there!

Try something like this:

SWITCH(
	SELECTEDVALUE( Priority ),
	"2 hours", "Pass",
	"4 hours", "Pass",
	"failed"
)

If your priority column is numeric then dont use double quotes.

Let me know if that helps!

[Anonymous]

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 · Accepted solution]

Try this:

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