Conditional calculation?

G

gjh3124

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.
 
G

Guest

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.
 
G

gjh3124

Hi,

Thanks for your reply.

I tried your suggestion and got the following:

B C
1 1
2 1 1
3 1 2
4 1 3
5 1 0
6 1 1
7 1 2

Unfortunately, once the "zero" condition is met, it causes the
condition checking to re-start.

What I am really after is a way to "store" or "set" a variable/constant
in Excel that, once set, remains set until actively un/re-set.

As an old DOS person, I see it as just like a DOS environment variable.

Any ideas?

Geoff.
 
G

Guest

Hi

That's exactly what my response was supposed to do!! I obviously
misunderstood your post. What do you want to use your variable/constant
for - once set? In the example you posted back - what output would you
expect to see?

Andy.
 
Top