View Single Post
 
Old 09-02-2014, 11:47 AM
blackjack blackjack is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Sep 2014
Posts: 13
blackjack is on a distinguished road
Default

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
Reply With Quote