I am trying to calculate the amount of time it will take to pay back a debt. Screen below.
Is it possible to do a formula like that will Sum 2 columns of data then return the text in adjacent cell when the sum value reaches XXX...?
i.e. I borrowed £2000. Add up the amount I have repayed, and the repayments scheduled then return the date that the full £2000 is paid back.
That way I can begin to play with the monthly amounts planned and see how it affects debt free date.
1 Attachment
@user16171 started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
I am trying to calculate the amount of time it will take to pay back a debt.
Screen below.
Is it possible to do a formula like that will Sum 2 columns of data then return the text in adjacent cell when the sum value reaches XXX...?
i.e.
I borrowed £2000.
Add up the amount I have repayed, and the repayments scheduled then return the date that the full £2000 is paid back.
That way I can begin to play with the monthly amounts planned and see how it affects debt free date.
1 Attachment