+ Reply to Thread
Results 1 to 6 of 6

Incrementing a Cell Value based on another Cell's Value

  1. #1
    Registered User
    Join Date
    12-14-2020
    Location
    Amsterdam
    MS-Off Ver
    Office 2016
    Posts
    5

    Red face Incrementing a Cell Value based on another Cell's Value

    Good Afternoon All,

    Thank you for your continued efforts on this forum, it has been greatly appreciated.

    I have a (hopefully) simple request - I am trying to create some forms where the value of one output cell is increased by 1 for every 4000 threshold increase in another cell.

    So basically, if the value in the input cell is 4000 or smaller, then the output cell should say 1. If the input number is 4001, the output should increase to 2. If the number is anything below 8000, the output should still be 2. Only when it reaches another 4000 threshold should it go up by another one. So if the number was 8001, it should go to 3.

    I have a sample attached if that makes more sense. I was previously using Cell/divided by 4000 but that wasn't really adequate as I don't want decimals. Any suggestions would be great!

    Thank you in advance,
    Attached Files Attached Files
    Last edited by papabear35; 12-15-2020 at 08:49 AM.

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Incrementing a Cell Value based on another Cell's Value

    and what happens when it reaches 12001?

  3. #3
    Registered User
    Join Date
    12-14-2020
    Location
    Amsterdam
    MS-Off Ver
    Office 2016
    Posts
    5

    Re: Incrementing a Cell Value based on another Cell's Value

    Hi Belinda,

    It should keep incrementing up, so:
    1-4000 = 1
    4001-8000 = 2
    8001 - 12000 = 3
    12001 - 16000 = 4
    and so on...

  4. #4
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Incrementing a Cell Value based on another Cell's Value

    Try this:
    =ROUNDUP(C4/4000,0)

  5. #5
    Registered User
    Join Date
    12-14-2020
    Location
    Amsterdam
    MS-Off Ver
    Office 2016
    Posts
    5

    Re: Incrementing a Cell Value based on another Cell's Value

    Thank you very much, Belinda! That's perfect! :D

    I appreciate the super quick help, you are the best! I will mark the thread as closed and provide rep

  6. #6
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Taiwan
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,380

    Re: Incrementing a Cell Value based on another Cell's Value

    B6 cell

    HTML Code: 

+ 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. [SOLVED] Drag a formula that references a cell from another Sheet (Skipping a cell incrementing 1)
    By DixieDiver in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-05-2013, 06:25 PM
  2. Replies: 4
    Last Post: 01-25-2013, 12:59 PM
  3. Incrementing value of cell based upon value in other cell
    By Baire in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-06-2013, 04:36 PM
  4. [SOLVED] Incrementing by 1 based on value of another cell
    By floids in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-27-2012, 01:19 PM
  5. incrementing field based on identical cell content.
    By echo313 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2011, 05:04 PM
  6. Replies: 4
    Last Post: 06-04-2009, 04:56 AM
  7. incrementing mm/yy based on value in other cell
    By George in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2006, 11:45 PM
  8. [SOLVED] incrementing a series of cells based on a value in another cell
    By mikeod in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-14-2005, 04:45 PM

Tags for this Thread

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