Hi everyone -

First time trying to use google groups, so thanks in advance for any
help with this task I am trying to work out. I have a real time
spread sheet that gets live market data. I need to be able to write
if then statements but when an occurence happens *ONE* time the cell
will return a value even if the data going into that cell would make
it change.

so for example, say i want to know if x100 then return a "1" in that
cell. what is happening now is that the real time data going into
that formula could be x,97, 98, 101, 103, 96, 101, 98, etc. So the
value of that cell will keep changing from 1 to 0 ( the if false value
to be returned).

what i am trying to do is that once the cell (x 100) it will then
return a 1 and *NOT* fluxuate. I can then use a macro/button to reset
things when i have completed an action (or taken a trade).

Thanks for any help with this area, it is really apprecaited!

Regards,

D. Eli
Momentumtrader