Hide Error Values And Error Indicators. 3 rows Hide error indicators in cells. Then do one of the following.
Some of the columns are blank null and that is where I get Error after I run the report. In the box on the right type ISERRORreference where reference is a reference to the cell that contains the error value. This makes the error text in these cells virtually invisible.
Selects all the cells in the current region that have the same formula in relative R1C1 terms as the active cell.
In the example below. Hide error values using conditional formatting Click on the cell that contains an error value. In your case set 3 labels to NULL and leave the 4th label alone or give it a name if you wish. How to hide the Excel error messages with the IFERROR or ISERROR functions.