You can't.

CELL2 either has a value in it or a formula; it can't have both.

You will get a circular reference because the formula contains a reference
to the cell that contains it

Regards

Trevor


"SE" wrote in message
...
How do I make a IF function do this? IF(CELL1 = X ,CELL1,CELL2) The
formula
is located in CELL2. When the IF function is false, then I want the value
in
CELL2 to stay the same. I get a circular reference with this format.