Distribute Sum across multiple cells based on Percentage|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hello all,

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?