title: How can I add multiple IF OR statements in an excel?
body: <p>I have to test a condition where the parameters can be more than one string. For eg: I would like to test</p>
  
  <pre><code>if (cell1="CA" or cell1="OR" or cell1="NV" or .....)` 
     print 1
  else 
     print 0
  </code></pre>
  
  <p>How do I do this? Excel only allows me to check maximum of 2 values in an or statement like this - </p>
  
  <pre><code>=IF((OR(U11="CT",U11="ME")),1,0)
  </code></pre>
  
  <p>Can someone help me how to do it?</p>
  
  <p>Thanks.</p>