Yeah, that is simple, but the OP wanted to put it in B1.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Bob Doyle" wrote
in message ...
This is quite possible without using circular references, per se. For
instance, if you wish to change the value of B2 only if the value of B1
is less than 1000, then you would write the following formula in cell
B2:
=IF(B1<1000,B1,B2)
Cell B2 would retain its value if B1 is greater than or equal to 1000,
but replace its value if B1 is less than 1000.
Bob Doyle
--
Bob Doyle
------------------------------------------------------------------------
Bob Doyle's Profile:
http://www.excelforum.com/member.php...o&userid=25473
View this thread: http://www.excelforum.com/showthread...hreadid=393067