Purchase an asset every 5 years

[Mike]

How do I show a purchase every 5 years after the initial purchase of an
asset. For instance, I have an individual, age 40, who wants to buy an auto
at the age of 42 and then buy one every 5 years. I can get the first year of
purchase but not the subsequent purchase every 5 years to build a table.
i.e.
Data field:
Current age of person 40
Cost of auto $20,000
Start date from now (in years) 2
Replacement of auto (in years) 5

Table: Purchase
Age of auto
40 $0
41 $0
42 $20,000
43 $0
44 $0
45
initial formula: =IF(age=$current age$+$start date from now$,use cost,0)

I appreciate the help.
Thank you

 

[Pete_UK]

With your first four parameters in cells B2 to B5, and your table data
starting in A10, put this formula in B10:

=IF(MOD(A10-B$2-B$4,B$5)=0,B$3,0)

and copy this down. A10 is the Age (variable), B2 is Current Age, B4
is Start Date, B3 is Auto Cost, B5 is Replacement Frequency.

Hope this helps.

Pete

 

[Mike]

Pete
It works great! Thank you, Cheers

With your first four parameters in cells B2 to B5, and your table data
starting in A10, put this formula in B10:

=IF(MOD(A10-B$2-B$4,B$5)=0,B$3,0)

and copy this down. A10 is the Age (variable), B2 is Current Age, B4
is Start Date, B3 is Auto Cost, B5 is Replacement Frequency.

Hope this helps.

Pete

 

[Pete_UK]

You'e welcome, Mike - thanks for feeding back.

Pete