End function
 

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.

End function
 

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.

End function
 

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.