title: Nested excel formula not showing expected result
body: <p>I am trying to achieve the following using nested excel formula;</p>
  <p><a href="https://i.stack.imgur.com/XMCrP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XMCrP.png" alt="enter image description here" /></a></p>
  <p>Below is the formula which I am using, but output which I am getting is as follows</p>
  <p><code>=IF(OR(H2=&quot;Y&quot;,I2=&quot;Y&quot;),1,IF(OR(H2=&quot;N&quot;,I2=&quot;N&quot;),0,IF(OR(H2=&quot;Y&quot;,I2=&quot;N&quot;),1,IF(OR(H2=&quot;&quot;,I2=&quot;&quot;),&quot;UNKNOWN&quot;,IF(OR(H2=&quot;&quot;,I2=&quot;N&quot;),&quot;UNKNOWN&quot;)))))</code></p>
  <p>Please let me know where is the mistake</p>
  <p><a href="https://i.stack.imgur.com/DZXvm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DZXvm.png" alt="enter image description here" /></a></p>