Excel Changing cell value based on another cell, but not always
Posted on 2013-11-15
Is there any way to have a cell change its value based on another cell, but also be able to enter a cell value if the first cell had nothing in it without wiping out a formula?
If Cell A1 has a value of 1
I want Cell B1 to have a value of 1 automatically.
But if Cell A1 has no value,
I want Cell B1 to be able to have a value put in without overwriting the formula.
Is that at all possible? Perhaps by having a formula in another cell, say C1, that is monitoring the value of A1, and if it has a value, place that value in B1?