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)
*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 100 0 100 100 0 0 100 100
I would give a dummy book, but I don't even know where to go with this formula...![]()
FY1 FY2 FY3 FY4 FY5 FY6 FY7 FY8 FY9 FY10 FY11 100 0 0 0 100 100 0 0 100 0 100
Any help would be much appreciated!
Bookmarks