I am building out a risk register and I'd like to use a formula to calculate the Risk Level, it will have to pull multiple combinations to get the formula though and I'm hitting a snag in my IF(AND formula.
Essentially it needs to breakdown info input in my Risk Probability + Risk Impact columns to calculate the Risk Level (for all 25 combinations)
Rare + Insignificant = Low Risk
Rare + Minor = Low Risk
Rare + Moderate = Low Risk
Moderate + Major = Major Risk
Help Article Resources
Check out the Formula Handbook template!