Hi,

I am trying to write a formula to assign text based on the range of values. For instance in risk scoring.

So if the risk score is 1-2, then the risk is low, if the risk score is 3-4 then the risk is medium and if the risk score is 5-6 then the risk is high.

I have it working for the low risk but the formula for the medium overwrites the high therefore "high risks are being labelled as Medium. Here is my formula so far:

IF({Risk Score} <“3”,“Low”,IF({Risk Score}>“2”<“6”,“Medium”,IF({Risk Score}>“5”,“High”)))

Try this:

IF({Risk Score} < “3”, “Low”, IF({Risk Score} < “5”, “Medium”, IF({Risk Score} < “7”, “High”, “Error”)))

or

IF({Risk Score} < “1”, “Error”, IF({Risk Score} < “3”, “Low”, IF({Risk Score} < “5”, “Medium”, IF({Risk Score} < “7”, “High”, “Error”))))