title: Excel formula need to be blank if there are no choice
body: <p>As picture below  in column &quot;C&quot; I have 6 variables consisting of one of the 3 choices  (Effective, Requires Improvement, Requires Immediate Attention). and in column &quot;E&quot; I have formula to count how many times each choice is repeated. Next in column &quot;G&quot; I have a formula that shows if any of the three choices repeats more than the rest, the result is the most frequent, and if the three choices are equal then the result &quot;Requires improvement&quot; .</p>
  <p>The formula works great but if results are 0 in column &quot;E&quot; then result in column &quot;G&quot; shows &quot;Requires Improvement&quot; but I need it to be blank because in column 'C' is not selected.
  Formula in column &quot;G&quot; IF(AND(F5&gt;F6,F5&gt;F7),&quot;Effective&quot;,IF(AND(F6&gt;=F5,F6&gt;=F7),&quot;Requires Improvement&quot;,IF(AND(F7&gt;F5,F7&gt;F6),&quot;Requires Immediate Attention&quot;)))<a href="https://i.stack.imgur.com/dVxEX.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dVxEX.jpg" alt="enter image description here" /></a></p>