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

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

j_robbins — Mon, 13 Feb 2023 14:29:19 GMT

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!

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

TheCADnoob — Mon, 13 Feb 2023 14:39:04 GMT

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

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

TheCADnoob — Mon, 13 Feb 2023 14:48:14 GMT

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.

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

dbroad — Mon, 13 Feb 2023 15:16:53 GMT

@TheCADnoob wrote:

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

Understatement of the year. 🙂