ExcelBanter - Cell Reference VS. Manual Input?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Cell Reference VS. Manual Input? (https://www.excelbanter.com/excel-worksheet-functions/159658-cell-reference-vs-manual-input.html)

K-Roq

Cell Reference VS. Manual Input?

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

Pete_UK

Cell Reference VS. Manual Input?

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

M. Authement

Cell Reference VS. Manual Input?

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

All times are GMT +1. The time now is 10:48 AM.