title: Excel IF Statement
body: <p>In my Excel worksheet E7 = 159.99 and H7 = 0.00%</p>
  
  <p>I am trying to use an IF statement to get the correct result which should be 5%.  However, if I use it in a nested IF statement like this:</p>
  
  <pre><code>=IF(H7&gt;=8%,20%,IF(H7&gt;=6%,15%,IF(H7&gt;=3%,10%,IF(H7&gt;0%,5%,IF(AND(H7=0%,E7&gt;0,),5%,0)))))
  </code></pre>
  
  <p>The result is 0%.</p>
  
  <p>When I break it down to just this part:  <code>=IF(AND(H7=0,E7&gt;0,5%)</code> I get the desired result of 5%.</p>
  
  <p>What is wrong with the way I originally did it for it to be producing 0% instead of 5%</p>