Hi,
Please see the picture linked to below and open it in a separate tab to zoom it:
https://imgur.com/a/8v1i12O
I am trying to create a formula to use in O2:Z2 (blue cells). I want it to do the following:
Look for invoices in C3:N3, if true, then divide it by number of mortgage months in B3, and plan this amount for the same number of months as in B3 - starting the month after receiving the invoice. It should stack with mortgages related to invoices in other periods.
As in the picture, we get the first invoice= 1200$ in 2020/01, the second invoice= 1200$ in 2020/06,
mortgage of the first invoice start by 2020/02 with 1200/12= 100$ a month during 12 months according to the number of mortgage months,
mortgage of the second invoice start by 2020/07 with 1200/12= 100$ a month during 12 months according to the number of mortgage months,
from 2020/07 since mortgages are overlappning, the mortgage payments stack and correspond 100+100= 200$ a month..
I tried to get this working but can't, would really appreciate your help here.
Please see the picture linked to below and open it in a separate tab to zoom it:
https://imgur.com/a/8v1i12O
I am trying to create a formula to use in O2:Z2 (blue cells). I want it to do the following:
Look for invoices in C3:N3, if true, then divide it by number of mortgage months in B3, and plan this amount for the same number of months as in B3 - starting the month after receiving the invoice. It should stack with mortgages related to invoices in other periods.
As in the picture, we get the first invoice= 1200$ in 2020/01, the second invoice= 1200$ in 2020/06,
mortgage of the first invoice start by 2020/02 with 1200/12= 100$ a month during 12 months according to the number of mortgage months,
mortgage of the second invoice start by 2020/07 with 1200/12= 100$ a month during 12 months according to the number of mortgage months,
from 2020/07 since mortgages are overlappning, the mortgage payments stack and correspond 100+100= 200$ a month..
I tried to get this working but can't, would really appreciate your help here.
Last edited: