You would need VBA for that although you might want to explain how you get
the "true" value
There might be a way using a function and circular references but it all
depends on what you are doing, the technique is described here

http://www.mcgimpsey.com/excel/timestamp.html


--


Regards,


Peo Sjoblom




"Troller" wrote in message
...
I have an if function on my worksheet that updates according to cells that
are updating dynamically throughout the day. I would like to have the
function stop running once the "true" value is reached. Also, the "true"
value is a number that updates dynamically as well, I would like that
number
to remain the same once the "true" value is reached, i.e. paste
special....value. Thanks for any input.