Cell A1 =IF(B1="",C1,B1)
What does this do?
Firstly, enter your data in cell C1, (you can set the ink attributes in col C to be the same as paper, so nothing shows up).
Then A1 will display the value in C1, but only if B1 is empty.
Hope this helps.
I need to create a spread sheet in which I can type a value in "cell A" then at a later date type a value in "cell B". when this is done I want "cell a" to default to zero. The problem is if I type the formula in cell a "when" I enter a value it overwrites the formula. I guess what I need is a formula tha I can put in "cell c" to affect "cell a"?
please see sheet below..basically when I enter a value in the actual column I want the value in the commited column to default to zero.