Target Cells
 

Hello All, I am fairly new to Excel formula programing. I know enough to be dangerous. Could some please help me here.
I need a traget cell left empty until I enter a value in one or more of the other cells that are part of a formula. How can I accomplish this or is it even possible? If you need further explanation I would be glad to send you a sample of what I am trying to do.

Thanks again

Not sure if this is what you want:
Suppose you want to add the contents of cell a1 to b1 and display the answer in c1, the formula for c1 is:

=IF(A1="","",A1+B1)

In other words, if A1 is blank display blank in c1 otherwise add a1 to b1

regards

mjd