title: How to wrap IF(ISBLANK( around all formulas
body: <p>I found this VBA code on the internet. It wraps "IFERROR" around all the formulas.</p>
  
  <pre><code>Sub Add_IFERROR()
  Dim R As Range
  
  For Each R In Selection.SpecialCells(xlCellTypeFormulas)
      If Left(R.Formula, 8) &lt;&gt; "=IFERROR" Then
          R.Formula = "=IFERROR(" &amp; Mid(R.Formula, 2) &amp; ","""")"
      End If
  Next R
  
  End Sub
  </code></pre>
  
  <p>I attempted to modify it so it wraps an "IF(ISBLANK(" but get a compile error.</p>
  
  <p>Looking to display blank (nothing, "") if ISBLANK=TRUE, if FALSE then display whatever is in the cell.</p>