title: Excel Nested IF statements returning False
body: <p>I am constructing a nested IF statement, and I believe I am missing an ELSE but I cannot figure out where. I have the following statement:</p>
  
  <pre><code>=
  
  IF(AND(B2="4",E2="R37",X2="Y"), "Non-Competing",
  
  IF(AND(B2="4",E2="R37",X2="N"), "Competing",
  
  IF(AND(B2="4",E2&lt;&gt;"R37",RIGHT(Z2,2)="00"), "Non-Competing",
  
  IF(AND(B2="4",E2&lt;&gt;"R37",RIGHT(Z2,2)&lt;&gt;"00"), "Competing",
  
  IF(B2&lt;&gt;"4","-")))))
  </code></pre>
  
  <p>I thought the last bit would cover the rest, but I am receiving a FALSE when I was hoping to get a result. For example, when B2=4, E2=R37, and X2=Y, I am expecting "Non-Competing" but am receiving FALSE. I also tried a combination with OR:</p>
  
  <pre><code>IF(OR(AND(B41="4",E41="R37",X41="Y"), 
  
  AND(B41="4",E41&lt;&gt;"R37",RIGHT(Z41,2)="00")), "Non-Competing",
  
  IF(OR(AND(B41="4",E41="R37",X41="N"), AND(B41="4",E41&lt;&gt;"R37",RIGHT(Z41,2)
  
  &lt;&gt;"00")), "Competing",
  
  IF(B41&lt;&gt;"4","-")))
  </code></pre>
  
  <p>...which gives me the same result. </p>
  
  <p>Any assistance would be greatly appreciated!</p>