
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 21, 2021 01:12 PM
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”
)
)
)
)
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 21, 2021 01:20 PM
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"
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 21, 2021 01:20 PM
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"
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 21, 2021 01:34 PM
Thank you! I appreciate your kindness here.
