Formula rewrite

HansVogelaar Last week you helped rewrite a formula in the attached example. In cells C33 and D33 you wrote the formula to only calculate a result if "No" or "Waiver" was selected in column B. I realized that if "Yes" was selected for all of column B, the default "Rarely" and "Negligible" would populate in C33 and D33. Is there a way to further modify this formula to calculate the formula as written if there are any "No" or "Waiver" answers and it will still exclude the "Yes" answers in the calculation, but if all answers in column B are "Yes" then it will calculate a Probability and Severity in C33 and D33? Basically, I want the formula to exclude the "Yes" answers in the calculation if there are any "No" or "Waiver" answers, but if everything is answered "Yes" then it will calculate a Probability and Severity in cells C33 and D33. "N/A" answers will still be excluded from the calculation.