Results 1 to 4 of 4

Formula needed based on cumulative numbers

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Formula needed based on cumulative numbers

    I have a spreadsheet with a column that is adding cumulative numbers such as below:

    2,250
    4,499
    6,738
    8,976
    11,214
    13,441
    15,668
    17,895
    20,110
    22,314
    24,517
    26,710
    28,902
    31,094
    33,287
    35,479
    37,671
    39,864
    42,056

    In another column I want to return a result of the number "1" for every increment to the nearest 7000

    So ultimately I would like a "1" displayed against the numbers above of:
    8976
    22314
    28902
    35479
    42056

    Seeing as those are the numbers that are above the nearest 7000 increment.

    If I only had a few numbers I would just plug it in but my numbers are going up to 600,000

    Any help would be appreciated. I'm happy to try and nut it out if I can at least know what formula to start with.

    Lu
    Last edited by ramblin; 06-21-2012 at 03:53 PM.

Thread Information

Users Browsing this Thread

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

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