? I'm not sure what you're trying to do.

I need to change the cell to blank or "", if the value is "#DIV/0!" (which it will be as this column is copied from somewhere else- a pivot table)

thanks for the attempt though