Does AutoCAD have an "=iferror..." function for cell formulas?

[j_robbins]

Hello again.  Another tables question.

I have a table with some rows that are not used, but remain in the final drawing.  In any cell that has an unused formula, the cell produces the expected #### symbol.  I tried to add =iferror(formula, "") to the cell like I would do in Excel, but it did not take.

Presently, my workaround is to change the text color of the error symbols to color 255, which is not visible in prints or .pdfs, but that seems like unnecessary extra work.  Is there a way to make the visible ####s invisible in prints without secondary manipulation?

I have already had instances where I forgot to change the color back after adding additional rows and sent out the drawings with no results visible, so I am trying to make this self-correcting.

Please see attached example.

Thanks!

[TheCADnoob]

In my experience, the table formula tools are pretty basic. If it's not on this list, it's not there. 

[TheCADnoob]

Id look into a lisp. 

You can use a lisp to populate your formulas and make color changes. 

It would take a little getting used to add it to your workflow but might save you the trouble of sending out the wrong thing. 

[dbroad]

---

@TheCADnoob wrote:

It would take a little getting used to ....

---

Understatement of the year. 🙂