Skip to main content
Solved

Help Correcting Nested IFAND Statement

  • July 21, 2021
  • 2 replies
  • 22 views
P

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”
)
)
)
)

Best answer by Kamille_Parks11

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"
   )
)

2 replies

Kamille_Parks11
Forum|alt.badge.img+27

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"
   )
)
P
  • Parke_Brown
  • Author
  • New Participant
  • July 21, 2021

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.

kuovonne
Terms & ConditionsAccessibility statement