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?
H Harald Staff Dec 30, 2003 #2 Only by considering those conditions within the formula, like these: =IF(B1=0,0,A1/B1) =IF(ISERROR(A1/B1),0,A1/B1)
Only by considering those conditions within the formula, like these: =IF(B1=0,0,A1/B1) =IF(ISERROR(A1/B1),0,A1/B1)
P Peter B Dec 30, 2003 #3 You can use this formula. It returns 0 if the value in cell B15 is error. Otherwise it returns the value in cell B14, =IF(ISERROR(B15),0,B14) Rgds, Peter B
You can use this formula. It returns 0 if the value in cell B15 is error. Otherwise it returns the value in cell B14, =IF(ISERROR(B15),0,B14) Rgds, Peter B
