Dear Experts,
Please find the sample excel. I need help in getting output in columns D, E, F , G, H and J
1. Column D
We need to determine the number of months left to the end date effective from May'22. For example, If the end date is 30th Jun 2022 then the remaining months pending should reflect as zero. If the start date is after 31st Mar 2023 then the remaining months should show as "Next FY".
2. In columns E, F, G, H, and I
If column D is 2 then in column E output should be (Balance / Number of months) * 2 while F, G, and H should be zero.
If column D is 3 then in column E output should be (Balance / Number of months) * 2 and in column F it should be (Balance / Number of months) * 1 while G and H should be zero.
It should be similar for the remaining months for example if it is 5 then (Balance / Number of months) * 2 in Column E and in Column F it should be (Balance / Number of months) * 3
If column D is Next FY, E, F, G and H should be zero but Column J should be C - I while I should be the sum of E,F,G and H
Please find the sample excel. I need help in getting output in columns D, E, F , G, H and J
1. Column D
We need to determine the number of months left to the end date effective from May'22. For example, If the end date is 30th Jun 2022 then the remaining months pending should reflect as zero. If the start date is after 31st Mar 2023 then the remaining months should show as "Next FY".
2. In columns E, F, G, H, and I
If column D is 2 then in column E output should be (Balance / Number of months) * 2 while F, G, and H should be zero.
If column D is 3 then in column E output should be (Balance / Number of months) * 2 and in column F it should be (Balance / Number of months) * 1 while G and H should be zero.
It should be similar for the remaining months for example if it is 5 then (Balance / Number of months) * 2 in Column E and in Column F it should be (Balance / Number of months) * 3
If column D is Next FY, E, F, G and H should be zero but Column J should be C - I while I should be the sum of E,F,G and H