Getting table to show only a particular lenghth

[Jillian Smith]

I am creating a table for a depreciation schedule. I am having the user enter the year the asset was purchased and the expected useful life (in years) into the input box and I want the output table to show only the amount of years useful years the assets has. Every year after that should not be shown on the table.

[Kaper]

use formula with if

=if(year_probably_derived_from_ROW()_function>usefull_life_cell_absolute_address$$, "", actual_formula_for_value_after_depreciation)