title: In Excel, if cell is blank OR formula result is 0, then how to show blank cell instead of #VALUE! error?
body: <p>I am trying to create a table which plans for the future. So, cells containing a future calculation are going to be blank. They also might be 0. In either case, I want to show a blank. Instead, I get <code>#VALUE!</code> error. I don't want to see that error.</p>
  
  <p>Here is what I tried, but it still shows the <code>#VALUE!</code> error:</p>
  
  <pre><code>=IF(OR(SUM(L7*D18)=0,SUM(L7*D18)=NA()),"",SUM(L7*D18))
  </code></pre>
  
  <p>I assumed that <code>NA()</code> means the cell is blank.</p>
  
  <p>I also tried these which all still show the <code>#VALUE!</code> error:</p>
  
  <pre><code>=IF(OR(SUM(L7*D18)=0,SUM(L7*D18)=""),"",SUM(L7*D18))
  
  =IF(OR(SUM(L7*D18)=0,"",SUM(L7*D18)="",""),"",SUM(L7*D18))
  
  =IF(OR(SUM(L7*D18)=0,"",SUM(L7*D18)=NA(),""),"",SUM(L7*D18))
  </code></pre>
  
  <p>None of these work and it still shows the <code>#VALUE!</code> error:</p>
  
  <p>How can I get this working so that <code>#VALUE!</code> is not returned and instead it is blank, if a referenced cell is blank or the result is 0?</p>