Worksheet Automation -- Changing start dates and end dates of growth curves & acct numbers

Hi,

I have a spreadsheet (see attached) that shows account uptake over a 48 month period. I have created the growth curve using linear interpolation so that I can have 4 growth curve segments over the 48 month period. I would like to automate the account uptake so I can change the following:
1) The start and end date of each growth segment
2) The number of accounts onboarded in month 1
3) The number of accounts onboarded at the end of each growth segment

I have managed to create the growth curves, but am unable to automate it according to the above inputs on the assumptions tab.

Does anyone know how to do this?

Any help appreciated.

- A

If I understand correctly the following formulas should accomplish what you want.
The formula for C2 and to the right is: =IFERROR(IF(B2+1<=$E15,B2+1,""),"")
The formula for C3 and to the right is:

Formula:

Please Login or Register  to view this content.

Both formulas have been applied to columns C:BI of the attached file.
Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.