Results 1 to 4 of 4

Acquisition Schedule Formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-01-2010
    Location
    United States, Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    116

    Acquisition Schedule Formula

    I have a row in my life cycle cost estimate (20 year projection) that needs to follow the following command:

    It should be zeroed out every year, except on acquisition years, and every 5th years. Essentially, I would like it so when I change the acquisition years, it will follow the above command.

    for example: (3 year acquisition cycle)

    FY1  FY2  FY3  FY4  FY5  FY6  FY7  FY8  FY9  FY10  FY11
    100    0    0  100    0  100  100    0    0   100   100
    *If i changed the acquisition cycle to 4 years, it would follow:

    FY1  FY2  FY3  FY4  FY5  FY6  FY7  FY8  FY9  FY10  FY11
    100    0    0    0  100  100    0    0  100     0   100
    I would give a dummy book, but I don't even know where to go with this formula...

    Any help would be much appreciated!
    Last edited by shg; 07-19-2010 at 03:13 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