You need to put the formula in C2, something like:

=IF(A2="","",B2-A2)

So, if A2 is empty then C2 will also appear empty, but if A2 contains
some value then it will be subtracted from B2 and the result will
appear in C2.

Hope this helps.

Pete


On Jul 2, 11:46 pm, "Ahh, Excel's Tough"
wrote:
Hi, I'm completely new to this board and was wondering if I could
possibly get some help. I'm trying to utilize a cell in which has a
formula in it, however everytime I insert a value to utilize the
formula, it of course.., gets cleared out. Is there anyway to
maintain
the formula inside the cell, then be able to just type a basic number
into the cell and have the formula calculate. The formula I have now
is =IF(A2=0, B2=0,""), I need when A2 is empty, for B2 to empty
itself
out. However, I need when A2 has something in it, for C2 to subtract
the value from B2, but I can't if the formula doesn't stay put.
Thanks
in advance!