title: Excel IF AND statement with percentage output
body: <p>I have a dataset of co-ordinates, except the co-ordinate is split into two column X and Y.</p>
  <p>I'm trying to find the percentage of co-ordinates in a single quadrant, and thought IF/AND statements would work i.e.</p>
  <pre><code>IF &quot;numbers in X Column is between -5 and 0&quot; AND &quot;numbers in Y is between -5 and 0&quot; then display total as Percentage of all data
  IF &quot;numbers in X Column is between 0 and 5&quot; AND &quot;numbers in Y is between 0 and 5&quot; then display total as Percentage of all data
  
  Etc..
  </code></pre>
  <p>I think that may be the easiest way but I'm stuck on three things;</p>
  <ol>
  <li>How to do it for negative numbers</li>
  <li>How to do &quot;is greater than a number BUT less than a number&quot; (rather
  than just greater/less than), and</li>
  <li>How to show results as a percentage (I only know how to return a
  TRUE or FALSE) i.e.:</li>
  </ol>
  <pre><code>=IF(AND(A2:A100&gt;5,B2:B100&gt;5),TRUE, FALSE)
  </code></pre>