title: Excel 2010 using IF AND formula
body: <p>I am trying to create a formula that says iF A1 is completed Show 0.  (ignoring others cell)
  If A1 it is not completed and is not past the due date(Cell B2) , Show 1, </p>
  
  <p>if it is not completed and past the due date show 3.  </p>
  
  <p>Based on 1,2 or 3 I can then display what I want (in this case Icons for Red, Yellow or Green)</p>
  
  <p>This is the closet formula I can come up with, but I am not there...</p>
  
  <p>=IF(AND(D2="Yes",B2>TODAY(),),1,0)</p>