title: Making two IF statements in a manual input cell which reference two different cells
body: <p>Currently, I have Data Validation for cell E4, stating formula =IF(E4>1,””,1).  This prohibits the user from entering any number other than 1 or zero.</p>
  
  <p>I need the user to manually enter the number “1” in cell E4 if a particular action is accomplished (a numerical checkbox, essentially).</p>
  
  <p>I also want the value of cell E4 to read “1” if cell B4 reads the number “3”.</p>
  
  <p>I’ve read several examples of nested IF statements and can’t find any that reference two different cells to decide the value of another cell.</p>
  
  <p>Can I make nested IF statements in Data Validation?  I haven’t been successful in doing so.</p>
  
  <p>The two formulas I need to affect cell E4 are;</p>
  
  <p>IF(E4>1,””,1)
  and
  IF(B4=3,E4=1,””)</p>
  
  <p>Any help is much appreciated.</p>