Hello everyone!

I’m trying to build this small formula when, depending on the probability, the priority status gets updated.

For example:

Probability 1-45 = Low Priority

Probability 46-65 = Medium Priority

Probability 66-100 = High Priority

I found another posts regarding this but none of the solutions seems to work. Right now the closest one is this:

IF({Probability}<45, {Priority}=“Low”,

IF(AND({Probability}>=45, {Probability}<=65, {Priority}=“Medium”,

IF({Probability}>65, {Priority}=“High”))))

I can’t make the “Medium” priority to work but the other two function perfectly. Can you help me sort this out?

Thank you!