SOLVED

# Rework a formula to only count "No" and "N/A" responses

Copper Contributor

# Rework a formula to only count "No" and "N/A" responses

@HansVogelaar You helped me write a formula a while back in the attached example. In cells C33 and D33 the formula assigns a number value to each of the Probability and Severity words in columns C and D and then averages those numbers to come up with an overall Probability and Severity at the bottom of columns C and D. Is there a way to rework this formula to only use the equation if the answer in column B is "No" or "N/A"? The reworked formula in C33 and D33 should read something like, "If there is a "No" or "N/A", perform the calculation. If "Yes" or "Waiver" is selected, then do not include in the calculation.

2 Replies
best response confirmed by lobo114 (Copper Contributor)
Solution

# Re: Rework a formula to only count "No" and "N/A" responses

See the attached version.

# Re: Rework a formula to only count "No" and "N/A" responses

That worked great, thank you!
1 best response

Accepted Solutions
best response confirmed by lobo114 (Copper Contributor)
Solution

# Re: Rework a formula to only count "No" and "N/A" responses

See the attached version.