Count in a circle

[sbloftness]

Is there an easy way to count in a circle? I need to enter a # in A1, then in B2 add 6, B3 add 6, so on, so forth until the total reaches 43. Then return to 1 and continue the count. I.E., if say B10 was 41, B11 would be 4.

I have looked at the loop function, but that does not seem to me to be what I need.

Thanks for any help.

[zbor]

If you enter number in B1 try this in B2 and pull down:

=MOD(B1+6,43)

[sbloftness]

That did the trick! Thank you so much!!!

[sbloftness]

Well, I put together what I was trying to do, with the =mod formula. It seems to do what I want, except that when a cell comes up as "37", it adds the "6" as I want, but returns a "0" in the next cell, instead of returning a "43". Any idea's on how to stop this? If one cell is a "38", it counts the "6" and returns the "1" as needed.

Thanks!

[gak67]

In B2:

=IF(A1+6>=43,A1+6-43,A1+6)

In B3 and dragged down:

=IF(B2+6>=43,B2+6-43,B2+6)

[gak67]

zbor's solutions is the one to go with. Mine will work, but his is simpler and better.

If your original number has to be in a1 then in B2 put =MOD(A1+6,43) and then in B3 put =MOD(B2+6,43) and then drag it down as necessary.

[gak67]

=if(mod(b1+6,43)=0,43,mod(b1+6,43))

[shg]

Or ...

	B	C
1	2	B1: Input
2	8	B2: =MOD(B1+5, 43) + 1
3	14
4	20
5	26
6	32
7	38
8	1
9	7
10	13
11	19
12	25
13	31
14	37
15	43
16	6

[sbloftness]

=MOD(B1+5, 43) + 1
This one did it! Thank you so much for your assistance!!

[shg]

You're welcome.