Hello,

Am curious as to whether it is possible to conditionally calculate (and
re-calculate) a worksheet?

For example:

1) a column contains a formula that simply adds the value in the
preceeding row to the value in the left adjacent cell, that is just a
cumulative total.

2) at a specified cumulative value, the value is reset to (say) zero
but only once.

3) when this event occurs, a 'flag' value is set in a worksheet cell
(say in the right adjacent cell)

Is it possible to preserve this flag value? Tthat is, set it once and
not re-set it?

I hope that this make sense!

Regards,

Geoff.