Perhaps I don't understand. By "after the field changes" do you mean "after the result in A1 changes"?
If so, it works fine for me. When I double-click in another cell (other than A1 and A2), the rand() formula recalculates. If the result is less than 0.1, then the result in A2 becomes 1. Otherwise, the result in A2 is 0. A2 will equal 1 about 10% of the time.
Here is a my file. I made the condition "<0.5" so the condition will be met more often. If I am misunderstanding, please clue me in.
|