Is there any way to set a cell to 0 if any error(eg DIV/0 or VALUE) occurs?
C courtesio99 Dec 30, 2003 #1 Is there any way to set a cell to 0 if any error(eg DIV/0 or VALUE) occurs?
P Philippon Dec 30, 2003 #2 You can you use the ISERROR(x) function that returns TRUE if x is error. Cf help file.