+ Reply to Thread
Results 1 to 4 of 4

Adding a certain number until minimum is reached

  1. #1
    dk
    Guest

    Adding a certain number until minimum is reached

    I'm having problem figuring out how to do this.

    If I have a number that is less that 20,000 in one cell, I want the next
    cell to add to it in multiples of 5,000 until a miniumum 20,000 is reached.
    I was wondering if anyone could help me with this.

    Thanks


  2. #2
    JE McGimpsey
    Guest

    Re: Adding a certain number until minimum is reached

    one way:

    A2: =INT((19999-A1)/5000)*5000+A1

    In article <[email protected]>,
    "dk" <[email protected]> wrote:

    > I'm having problem figuring out how to do this.
    >
    > If I have a number that is less that 20,000 in one cell, I want the next
    > cell to add to it in multiples of 5,000 until a miniumum 20,000 is reached.
    > I was wondering if anyone could help me with this.
    >
    > Thanks


  3. #3
    Ron Coderre
    Guest

    RE: Adding a certain number until minimum is reached

    Try this:
    A1: (some number less than 20,000)
    Select from A1 down through A50
    Edit>Fill>Series
    Series in: Columns
    Step: 5000
    Stop Value: 20000
    Click [OK]

    Does that help?

    ***********
    Regards,
    Ron


    "dk" wrote:

    > I'm having problem figuring out how to do this.
    >
    > If I have a number that is less that 20,000 in one cell, I want the next
    > cell to add to it in multiples of 5,000 until a miniumum 20,000 is reached.
    > I was wondering if anyone could help me with this.
    >
    > Thanks
    >


  4. #4
    Dave Peterson
    Guest

    Re: Adding a certain number until minimum is reached

    One way:

    =IF(A1>=20000,A1,A1+CEILING(20000-A1,5000))

    (I think....)



    dk wrote:
    >
    > I'm having problem figuring out how to do this.
    >
    > If I have a number that is less that 20,000 in one cell, I want the next
    > cell to add to it in multiples of 5,000 until a miniumum 20,000 is reached.
    > I was wondering if anyone could help me with this.
    >
    > Thanks


    --

    Dave Peterson

+ Reply to Thread

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