You may want to try adding a column for the IF statement. Example:

Column A: [Data Entry 1]
Column B: [Data Entry 2]
Column C: =A1*B1
Column D: =IF(ISERROR(C1), 0, C1)

Hide column C.

If either column A or B is deleted, the formula in C will result in an
error thus rendering a 0.


--
Slave2Six
------------------------------------------------------------------------
Slave2Six's Profile: http://www.excelforum.com/member.php...o&userid=36904
View this thread: http://www.excelforum.com/showthread...hreadid=567233