End function

[Guest]

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.

 

[Peo Sjoblom]

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

 

[Guest]

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

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