Or make A2 your 'override input' cell and make the formula in B1:
=IF(A2="",A1,A2).


"Pete_UK" wrote in message
oups.com...
You could have a formula in B1 like =A1 and then overwrite the formula
with a manual value if you want to change it.

Hope this helps.

Pete

On Sep 25, 8:56 pm, K-Roq wrote:
Is there a way to program a cell to display a referenced cell UNLESS you
choose to override it with a manually inputed value? Thanks in advance