How to use the formula for the future Years?

Question

Hi

I have data which I posted below, I have to create the same for the future years as well. The formula is Amount/Row1*0.5 for first and last years and Amount/Row1 for the remaining years. and First row will decide for how many years we have to calculate. Is there any solution for this?

252525252525252525Year2019A2019B2020A2020B2021A2021B2022A2022B2023A2023B2024A2024B2025A2026B2027A2027B2028A2028BAmount100005000001100012000100002000010000600005000010000        2019      25006000125001000        2020      500012000250002000        2021      250012000125002000        2022       12000 2000        2023       12000 2000        2024       6000 1000        2025                  2026                  2027                  2028

AYESHASIDIKHA · Answer

I have given enough information about the output I want, Could you please look into that? Thanks in advance

AYESHASIDIKHA · Answer

Apologies for not providing enough information,Attaching the input file .

This process was doing manually earlier but for the Future Years I need to automate. The expected output is for 2024 year.

The formula for 2024A is, It should divide the amount in 2 years(It is dependent on Amount).
from the current year to next 2 years and the first and last year formula is Amount/No.of Year*0.5
and the values for the middle year is Amount/No.of Year.(Which should be equal to the Amount)

Same for the 2024B but it will calculate for the next years from the current year. For the first and last year the formula is
Amount/No.of Year*0.5 and the values for the middle year is Amount/No.of Year.(Which should be equal to the Amount).

Sample_Amount.xlsx

caltang · Answer

Yeah @AYESHASIDIKHA  this is super confusing lol. Can you provide some Excel raw data, and can you give the raw form of data + an expected output? Can't make heads or tails of your query.