One way:

Record a macro while you enter the formula (with the source cell < 100
of course).

Another possibility, if your valid changing values will never be
negative:

=IF(A1<0,0,IF(B1=1,1,--(A1100)))

Then just enter a negative number in A1.

In article . com,
momentumtrader wrote:

How do i reset it then to go back to the state where it is looking for
x100.

So for example, i want the cell to = 1 and stay in that condition when
looking for x 100. after that has occured, i will be doing
something, trading, etc. once that trade is complete we then are
looking once again for when x 100. can i add a button that resets
this so it is looking for a new iteration (or something like that).