+ Reply to Thread
Results 1 to 2 of 2

Making a rollout schedule using offset and not nested IF!

  1. #1
    Registered User
    Join Date

    Making a rollout schedule using offset and not nested IF!


    I am new and hope that someone can help me with my problem =).

    I am trying to make a rollout schedule, whish is a plan for how many of X items to build pr Week. I have a list of milestones and their lead times. Please see the attached excel-file with example.Testing Offset.xls

    I have defined the curve of the rollout graph in the ref. Milestone. I then use nested IF to get this schedule. In cell K8:

    This only works for up to 7 weeks of leadtime, which is the max number of nested IF. How can I use OFFSET to do the same?

    Thanks a lot!

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    Surrey, England
    MS-Off Ver
    Excel 2013

    Please Login or Register  to view this content.
    pasted into K8.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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