Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Help Correcting Nested IFAND Statement

Topic Labels: Formulas
Solved
Jump to Solution
1253 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Parke_Brown
4 - Data Explorer
4 - Data Explorer

After searching here and looking at the nested ifs reference, I believe I’m close, but not quite there.

I want the formula to look at values in two fields (likelihood of a problem; severity of a problem) and return a third value (combined level) depending on the combination. A sample of part of it is below.

Example formula so far:

IF(
AND({Likelihood} = “Improbable”, AND({Severity} = “Acceptable”)),
“Low”,
IF(
AND({Likelihood} = “Improbable”, AND({Severity} = “Tolerable”)),
“Medium”,
IF(
AND({Likelihood} = “Improbable”, AND({Severity} = “Undesirable”)),
“Medium”,
IF(
AND({Likelihood} = “Improbable”, AND({Severity} = “Intolerable”)),
“High”
)
)
)
)

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

Instead of
AND({Likelihood} = "Improbable", AND({Severity} = "Acceptable"))
do this:
AND({Likelihood} = "Improbable", {Severity} = "Acceptable")

Or simplify your formula to only ask each “question” once:

IF(
   {Likelihood} = "Improbable",
   SWITCH(
      {Severity},
      "Acceptable", "Low",
      "Tolerable", "Medium",
      "Undesirable", "Medium",
      "Intolerable", "High"
   )
)

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

Instead of
AND({Likelihood} = "Improbable", AND({Severity} = "Acceptable"))
do this:
AND({Likelihood} = "Improbable", {Severity} = "Acceptable")

Or simplify your formula to only ask each “question” once:

IF(
   {Likelihood} = "Improbable",
   SWITCH(
      {Severity},
      "Acceptable", "Low",
      "Tolerable", "Medium",
      "Undesirable", "Medium",
      "Intolerable", "High"
   )
)

Thank you! I appreciate your kindness here.