# Start with number in cell a1 then increase the number in the next cell until it reaches 8

1. ## Start with number in cell a1 then increase the number in the next cell until it reaches 8

Hi,

I am hoping this is a simple formula but I just cannot figure it out.

I have the number 1 in cell a1, in cell b1 I want it to do =a1+1, then in cell c1 =b1+1. I want this to keep doing the same thing until this number reaches 8 then start again at 1.

Is this possible?

2. ## Re: Start with number in cell a1 then increase the number in the next cell until it reache

This should do it (entered in B1 and drag down)

Formula:
`Please Login or Register  to view this content.`

3. Originally Posted by PFDave
This should do it (entered in B1 and drag down)

Formula:
`Please Login or Register  to view this content.`
Perfect thank you!

4. ## Re: Start with number in cell a1 then increase the number in the next cell until it reache

Another way:

=MOD(A1,8)+1

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1