Hi

Do you mean something like this:
=IF(AND(B5+C4=4,COUNTIF($C$1:$C4,0)=0),0,B5+C4)
This will create a running total in column C of values in column B. When the
total reaches 3, it will reset to 0 and then carry on, without resetting.
Is that close to what you want?

Andy.

wrote in message
oups.com...
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.