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 ()
    )
)
PabloDeheza's avatar
PabloDeheza
Solution Sage
3 years ago

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'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 ()
    )
)