Target Cells

B

Bohdon

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

[email protected]
 
D

dalymjl

Bohdon said:
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?
Click to expand...

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
 
Top