If / Then Formula in the Risks List in PWA/SharePoint

N

NKR

Hi. I'm trying to create a forumla that recognizes a score and assigns a
label to it, such as "High, Medium, or Low." I was able to get part of it to
work (see below), but I'm struggling with the remaining calculation. Can
anyone assist?

=IF Probability * Impact >50, "High" (this is the part that works)

What I want to add are qualifiers to get the medium and low designation.
Our logic is good, but we keep getting syntax errors. What I've come up with
is:

=IF Probability * Impact >50, "High"
IF (Probability * Impact <50 and Probability * Impact >20, "Medium"), "Low"

Thank you for your help.
-NKR
 
M

Marc Soester

Hi NKR
I assume that probability and Impact is an extra field that the user needs
to choose. If so try this
try this
IiF(Probability * Impact <20, "Medium",Iif(Probability * Impact >50,
"High", "Low"))
This should do the trick
Let me know if it worked
 
N

NKR

Hi Marc,

Thanks for your response. Your solution was what we needed - we used the
following below and it worked like a charm.

=IF((Probability*Impact)>50,"High",IF((Probability*Impact)>21,"Medium","Low"))

Thanks again for your help!
-Nikole
 
Top