yaswanth92
Member
Hello Excel experts,
Happy New Year!
I need your assistance in solving a logic. Please find attached the file wherein I have two tables, top one is the input and the one below is where the results should populate (dark yellow shaded cells).
Table 1:
Column B - Cost description
Column C - Cost type to choose: Fixed or Variable
Column D - Start year for each cost. Inputs are restricted with data validation from year 1-20. If its year 2, the cost should start from year 2 onwards.
Column E - Frequency of the cost. Inputs are restricted with data validation from year 0-20. For example, if the frequency of cost 1 is 0 means, it's a one time cost that should sit in only year 1 of the table below. If the frequency of cost 2 is 3 years, the cost should incur every years starting from year 2.
Column F - Total of each cost
Table 2:
Column B - I have years from 1-20
Column C - Fixed cost wherein I need all the fixed costs of the above table added as per the start year and frequency.
Column D - Variable cost wherein I need all the variable costs of the above table added as per the start year and frequency.
Thank you for your valuable time and effort.
Happy New Year!
I need your assistance in solving a logic. Please find attached the file wherein I have two tables, top one is the input and the one below is where the results should populate (dark yellow shaded cells).
Table 1:
Column B - Cost description
Column C - Cost type to choose: Fixed or Variable
Column D - Start year for each cost. Inputs are restricted with data validation from year 1-20. If its year 2, the cost should start from year 2 onwards.
Column E - Frequency of the cost. Inputs are restricted with data validation from year 0-20. For example, if the frequency of cost 1 is 0 means, it's a one time cost that should sit in only year 1 of the table below. If the frequency of cost 2 is 3 years, the cost should incur every years starting from year 2.
Column F - Total of each cost
Table 2:
Column B - I have years from 1-20
Column C - Fixed cost wherein I need all the fixed costs of the above table added as per the start year and frequency.
Column D - Variable cost wherein I need all the variable costs of the above table added as per the start year and frequency.
Thank you for your valuable time and effort.
Attachments
Last edited by a moderator: