View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

You cannot do that. By entering a formula, you immediately overwrite what
was previously there. In other words, a cell holds a value or a formula, not
both.

You would need to put the formula in another cell.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rosendo" wrote in message
...
I want to keep the current value of a cell if certain condition exist, or
chage it if that condition does not exist. Is that posible without

using a
circular referencies ?

IF (CONDICTION, CHANGE THE VALUE, KEEP THE PREVIOUS VALUE)