Here's the formula....

cell P483 = cellname * 10%
=IF(ISERROR(P483)="True",0,P483)

when I delete the column with cellname in it, everything goes #REF!.

Thanks for all your help. I feel better because I thought it should be this
easy as well but it's not working


"Slave2Six" wrote:


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