title: How to use an IF statement for multiple cells?
body: <p>I have this statement as the IF statement </p>
  
  <pre><code>=IF(AND(C5,D5,E5,F5,G5,H5,I5= "x"),"1","0")
  </code></pre>
  
  <p>However it only marks a 1 if the last one has an x in it, I want it to check if whether those cells all have x then it should have a 1, otherwise it would be a 0.</p>