Can you change the value of a cell from a formula that is not located on that
cell ? How do you reference that other cell ?

Rosendo

"Bob Phillips" wrote:

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)