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.

Attached Files

Book1.xlsx (9.0 KB, 8 views)

It's my fault I'm not explaining this very well so I'll try a couple of ways.

I need a running total every time the random number in A1<.1. I need it to add 1 each time the random number is less than .1. The reset to 0 is what I'm trying to avoid. I'm looking for a way to have A2 add to itself each time the condition is met.

example
A1 .06, A2 1
recalculate A1 .4, A2 1
recalculate A1 .09, A2 2