Hello,
I did not get any replies to my question so if any one wants to give it a try this is again what I need.
1. Cell A3 returns a different values every second.
2. Cell P3 returns the result of a formula as either as TRUE or FALSE.
I need to store (in cell B3) the corresponding value of cell A3 when P3 becomes "TRUE" and leave it static or unchanged when cell A3 changes again.
Thank You
Reading your question I suppose you need VBA as an solution.
VBA is not my expertise, so maybe I can't help you enough with that.
Having said that, I think you get better help if you add an small excell file, without confidential information.
Add some examples in the file, and also add the desired (expected) result in your file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Have you explored circular referencing?
For example:
=IF(B3=0,IF(P3=TRUE,A3,B3),B3)
Then you need to enable iterative calculation under Options -> Formulas.
This formula will continue to evaluate itself until it changes, and then it will not update itself once it is no longer 0.
Last edited by daffodil11; 02-09-2015 at 06:35 PM.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Hello,
Thanks for your answer.
It does work, however, how can I reset cell B3 to start doing its calculation again.
Thank You
Reset cell works great
Last edited by CMG2; 02-10-2015 at 12:15 AM.
Hello,
I found a way of resetting the loop by adding IF(B1=TRUE,FALSE,) to your formula [=IF(B1=TRUE,FALSE,IF(B3=0,IF(P3=TRUE,A3,B3),B3))], and setting cell B1 to =IF(P3=FALSE,TRUE,FALSE).
In that way when P3 becomes FALSE the loop is reset.
Thank You again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks