Hi, is there a way to enter an IF function into cell #1 that changes a value
in cell #2?

Basically this is what I'm trying to do:

Cell #3 may or may not have data.

If it does have data, then cell #2 should have the same data. If not, then
cell #2 keeps whatever data it had.

So I wanted to enter a formula in cell #1 that checks if cell #3 is empty,
if not, then override cell #2.

Not without code. You can however store the #2 value in say cell 4, then if
cell3="",cell4,cell3.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"hfazal" wrote:

Hi, is there a way to enter an IF function into cell #1 that changes a value
in cell #2?

Basically this is what I'm trying to do:

Cell #3 may or may not have data.

If it does have data, then cell #2 should have the same data. If not, then
cell #2 keeps whatever data it had.

So I wanted to enter a formula in cell #1 that checks if cell #3 is empty,
if not, then override cell #2.