View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hfazal hfazal is offline
external usenet poster
 
Posts: 22
Default UPDATE ANOTHER CELL

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.