UPDATE ANOTHER CELL

  • Thread starter Thread starter hfazal
  • Start date Start date
H

hfazal

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.
 
Back
Top