December 17, 2020
I need help with the attached section of my Excel Sheet.
I would like to enter an amount in the rows DN to DR and then get certain percentages of that amount distributed over the next 4 years.
I work in a field where an incoming Order will be worked on over 4 years. So that means if we receive an Order in 2021, we will be receiving 20% of the total Order amount in 2021, 30% in 2022, 30% in 2023 and 20% in 2024. (So if we received an Order for 1000 in 2021, it should show 200 in column HI, 300 in column HJ, and so forth...)
I would like this to show in my Excel file in the columns HI to HO.
Also for example if I receive an order in 2025 I would like it to show 20% of that order in 2025, 30% in 2026 and the remaining 50% in the column HO since the sheet doesn't go beyond that year.
Does that explanation make sense and does anyone know a solution?