title: IF formula returning 0 or 1 depending on values in 3 cells?
body: <p>I'm a beginner in Excel and I've been trying to make an <code>IF</code> formula  that will return 0 or 1 if certain conditions are met.</p>
  
  <p>The formula in A3 must look at </p>
  
  <ul>
  <li>A1 to see if A1=1111 </li>
  <li>A2 to see if A2=21,00 </li>
  <li>A2 to see if A2=24,00. </li>
  </ul>
  
  <p>So, if A1=1111 and A2=21,00 or 24,00 the result in A3 must be 1, but if A1=1111 and A2 is any other value, A3 must be 0.<br> LE: If in other rows the value is 1112 the formula should return 1.</p>