logical test.......(h5=b5)+(b6=375)
true= b5
false= false

Values b5, h5 and b6 update dynamically throughout the day.


"Peo Sjoblom" wrote:

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.