Forum Discussion

crimsonb's avatar
crimsonb
Copper Contributor
Feb 22, 2022
Solved

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...
  • Riny_van_Eekelen's avatar
    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.

Resources