UPDATE ANOTHER CELL

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.
 
J

John Bundy

Not without code. You can however store the #2 value in say cell 4, then if
cell3="",cell4,cell3.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top