pierce2284
New Member
- Joined
- Jul 14, 2015
- Messages
- 5
I am developing a pro-forma and need to capture different types of funding during "X" time periods. However, I am not sure the best way to do this. I am thinking an if statement but I am not sure if this would be the best approach.
As an example:
- Debt Source #1 will start in year 1 but will end in year 5, and
- Debt Source #2 will start in year 6 and end in year 12
What is the best way to tell excel to recognize Debt source #1 during years 1-5 and then switch to debt source #2?
I look forward to your help. Thank you in advance!
As an example:
- Debt Source #1 will start in year 1 but will end in year 5, and
- Debt Source #2 will start in year 6 and end in year 12
What is the best way to tell excel to recognize Debt source #1 during years 1-5 and then switch to debt source #2?
I look forward to your help. Thank you in advance!
