Workaround for "Formula omits adjacent cells"
<p>In Excel, with the following function:</p>

<pre><code>=IF(AND(N3=1,ISNUMBER(D3),ISNUMBER(E3)),SUM(D3:E3)-2,IF(AND(N3=1,D3="",E3=""),G3,IF(N3=1,"",IF(AND(N3=0,ISNUMBER(D3)),D3-1,IF(AND(N3=0,ISNUMBER(E3)),E3-1,IF(AND(N3=0,D3="",E3=""),G3,IF(N3="","",G3)))))))
</code></pre>

<p>I get the error:</p>

<blockquote>
  <p>Formula omits adjacent cells</p>
</blockquote>

<p>How can I fix the formula to avoid getting the error?</p>