Cell Reference VS. Manual Input?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Or make A2 your 'override input' cell and make the formula in B1:
=IF(A2="",A1,A2).
 
Back
Top