title: How do I recognize "#VALUE!" in Excel spreadsheets?
body: <p>I'd like to write a formula such that if cell A1 displays <code>#VALUE!</code>, say <code>TRUE</code> in cell B1.</p>
  
  <p>Here's my formula in cell B1:</p>
  
  <pre><code>=IF(A1="#VALUE!", "TRUE", "FALSE")
  </code></pre>
  
  <p>I get <code>FALSE</code> when A1 does not say <code>#VALUE!</code> so that part is fine.  But, when it does say <code>#VALUE!</code>, I get a <code>#VALUE!</code> error in cell B1, when I want it to say <code>TRUE</code>.  How do I do this?</p>