Good day
I'm looking for a formula that can help with replacement years. Say I buy a Laptop in 2020, and have a replacement criteria in cell C3 that is "3" years.
Thus I will this I will replace it in 2023 2026 2029 2032.....
The formula needs to pull the cost into each Colum for the specific year as I have 300 different items.
A B C D II F G H I J K L
[TABLE="width: 778"]
<colgroup><col><col><col><col><col><col span="7"></colgroup><tbody>[TR]
[TD][TABLE="width: 781"]
<colgroup><col><col><col><col><col><col span="6"><col></colgroup><tbody>[TR]
[TD]Description[/TD]
[TD]Purchace Date[/TD]
[TD]Interval[/TD]
[TD]Price[/TD]
[TD] [/TD]
[TD="align: right"]2020[/TD]
[TD="align: right"]2021[/TD]
[TD="align: right"]2022[/TD]
[TD="align: right"]2023[/TD]
[TD="align: right"]2024[/TD]
[TD="align: right"]2025[/TD]
[TD="align: right"]2026[/TD]
[/TR]
[TR]
[TD]Laptop[/TD]
[TD="align: right"]2020[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5000[/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]
Many Thanks
I'm looking for a formula that can help with replacement years. Say I buy a Laptop in 2020, and have a replacement criteria in cell C3 that is "3" years.
Thus I will this I will replace it in 2023 2026 2029 2032.....
The formula needs to pull the cost into each Colum for the specific year as I have 300 different items.
A B C D II F G H I J K L
[TABLE="width: 778"]
<colgroup><col><col><col><col><col><col span="7"></colgroup><tbody>[TR]
[TD][TABLE="width: 781"]
<colgroup><col><col><col><col><col><col span="6"><col></colgroup><tbody>[TR]
[TD]Description[/TD]
[TD]Purchace Date[/TD]
[TD]Interval[/TD]
[TD]Price[/TD]
[TD] [/TD]
[TD="align: right"]2020[/TD]
[TD="align: right"]2021[/TD]
[TD="align: right"]2022[/TD]
[TD="align: right"]2023[/TD]
[TD="align: right"]2024[/TD]
[TD="align: right"]2025[/TD]
[TD="align: right"]2026[/TD]
[/TR]
[TR]
[TD]Laptop[/TD]
[TD="align: right"]2020[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5000[/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]
Many Thanks