Forum Discussion
crimsonb
Feb 22, 2022Copper Contributor
Adding and stopping payments. How to make a reference cell the number of year a payment is paid
I am trying to find a way to add up different financing and paybacks. The "3" in the input cell is the number of years each payment will be paid back. The different payments are below the "3". I ne...
- Feb 22, 2022
crimsonb Not the most elegant and dynamic solution but with some (hidden) helper columns I could achieve what you asked for, I think. But it requires some manual adjustments if you want to expand the schedule. See if the attached example is something that could work for you.
Riny_van_Eekelen
Feb 22, 2022Platinum Contributor
crimsonb Not the most elegant and dynamic solution but with some (hidden) helper columns I could achieve what you asked for, I think. But it requires some manual adjustments if you want to expand the schedule. See if the attached example is something that could work for you.
crimsonb
Feb 22, 2022Copper Contributor
Riny_van_Eekelen This works! Thank you so much! I really appreciate it.