No you cannot, not with a function.

Best you get is in say C1 use

=IF(condition,B1,"")

you could hide column B so that you only see the result, not the route to
that result.

--

HTH

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


"Rosendo" wrote in message
...
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)