Use a formula of your choice to fill in the Risk Level column with the following guidelines: If the sum of Impact and Likelihood is in the range of 0-5, the Risk Level is Tier 4. If the sum of Impact and Likelihood is in the range of 6-10, the Risk Level is Tier 3. If the sum of Impact and Likelihood is in the range of 11-15, the Risk Level is Tier 2. If the sum of Impact and Likelihood is in the range of 16-20, the Risk Level is Tier 1.
Solved by T. W. in 23 mins