Results 1 to 8 of 8

Incremental Increases based on criteria

Threaded View

  1. #1
    Registered User
    Join Date
    11-04-2019
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    7

    Incremental Increases based on criteria

    Hi

    I am working on a model looking at the launch of a new product. On the attached file I am using the sales inputs tab to say how many distribution points (DPs) we will start with, which month a product will be launched into a particular outlet type and how those DPs will increase during 2020 - 2023. Lastly the frequency column will say how often the increase will take place. So for example the product will be launched into outlet type 1 in Jan 2020 starting in 20 DPs. It will increase by 10 DPs every month in 2020 then increase by 20 DPs every month in 2021.

    The formula I have come up with, following much google time, works a dream but goes wrong when the year ticks over and I cannot work out why. The increase of 10 is fine in 2020 but in Jan 2021 it jumps by 130.

    Anyone have a suggestion?

    Many thanks

    Chris
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. A incremental Auto numbering based on two columns data criteria
    By vaibhavch in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-25-2018, 12:03 AM
  2. Formula for incremental sum with criteria
    By XLalbania in forum Excel General
    Replies: 3
    Last Post: 03-16-2017, 08:37 AM
  3. [SOLVED] Incremental increases within formula
    By rush381 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-11-2017, 05:41 PM
  4. Replies: 1
    Last Post: 07-19-2016, 05:07 PM
  5. Review row criteria and paste on incremental row on another sheet
    By jdannis79 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2016, 12:26 PM
  6. [SOLVED] Numerical values increases as name increases
    By Jbelle7435 in forum Excel General
    Replies: 3
    Last Post: 09-16-2014, 01:41 PM
  7. [SOLVED] Increasing one cells value based on incremental increases in another
    By AndyPandy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-19-2013, 08:45 AM

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