+ Reply to Thread
Results 1 to 3 of 3

For every "X" amount, do "Y"

  1. #1
    Registered User
    Join Date
    07-18-2007
    Location
    Seattle, WA, USA
    MS-Off Ver
    2016
    Posts
    42

    For every "X" amount, do "Y"

    I'm sure this has a simple answer I'm overlooking, but how can I calculate something based on the following situation?

    Cell A1 contains a variable number.
    Cell A2 contains a set number.
    Cell A3 contains a formula that multiplies A2 at certain intervals.

    Lets say the interval is 5. In essence, the following would happen.

    When A1=0-4, A3 does nothing.
    When A1=5-9, A3 multiplies A2 by 1.
    When A1=10-14, A3 multiplies A2 by 2.
    When A1=15-19, A3 multiplies A2 by 3.
    etc.

    Hence the "interval" is 5, and the function increases the multiplication amount by a factor of 1 for each "interval".


  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    = A2 * Int ( A /5)

  3. #3
    Registered User
    Join Date
    07-18-2007
    Location
    Seattle, WA, USA
    MS-Off Ver
    2016
    Posts
    42
    Wow, fast response! I knew it was something easy...

    Thank you!

+ 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