title: Workaround for "Formula omits adjacent cells"
body: <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>