Cell Reference VS. Manual Input?

K

K-Roq

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
 
P

Pete_UK

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
 
M

M. Authement

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