Counter Reset??

Hi,

Can anyone help to advice how to solve my current issues.

Let said,

Col A - Col B will give you the answer said 25 in Col C

Is there a condition or formula, in which when Col C reaches 25, it will reset the number back to zero.

Thank you in advance

loh

Originally Posted by loh69

Hi,

Can anyone help to advice how to solve my current issues.

Let said,

Col A - Col B will give you the answer said 25 in Col C

Is there a condition or formula, in which when Col C reaches 25, it will reset the number back to zero.

Thank you in advance

loh

did you mean on a line-by-line basis? or as a total-column basis?

=MOD((A1+B1),25)

which does not reset the values, but shows answers as would be the remainder were A + B divided by 25.

=MOD((SUM(A:A)+SUM(B:B)),25)

alternately
=MOD(SUM(A:B),25)

will do the 'total' column.

---

Nope, this is what i want.

meaning, if A1 + B1 = 25, then A1 figures will becomes B1 figures, then the sum of A1+B1 wille zero.

Thanks

Loh