+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Forum Contributor
    Join Date
    11-07-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    126

    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. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    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: copy to clipboard
    Please Login or Register  to view this content.
    Please do add reputation where you see fit, it's nice to be nice and we all enjoy a pat on the back

    Please also mark your thread as solved once it has been.

  3. #3
    Forum Contributor
    Join Date
    11-07-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    126
    Quote Originally Posted by PFDave View Post
    This should do it (entered in B1 and drag down)

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

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

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

    Another way:

    =MOD(A1,8)+1

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Increase Value until Value in another cell reaches target
    By TTB_Supplies in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-14-2023, 09:57 AM
  2. [SOLVED] Can you Play sound when a cell reaches a number like 12
    By gdclyde in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-26-2014, 03:04 PM
  3. changing a value of a cell when it reaches a certain number.
    By intotec in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-13-2013, 03:04 PM
  4. [SOLVED] How to subtract multiple cells from a cell and report soldout when main number reaches 0
    By QuietForce in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-02-2012, 01:43 AM
  5. Macro to Autofill number/formula until it reaches cell containing specific text
    By adamski911 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2012, 12:33 PM
  6. Replies: 6
    Last Post: 03-30-2010, 11:11 AM
  7. Excel,increase Invoice Number At Start
    By LIGER in forum Excel General
    Replies: 1
    Last Post: 06-17-2005, 01:05 PM

Bookmarks

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