Quote:
|
Originally Posted by Bohdon
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?
|
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