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

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



On Apr 25, 7:54*pm, Mike wrote:
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
It works great! Thank you, Cheers

"Pete_UK" wrote:

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



On Apr 25, 7:54 pm, Mike wrote:
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

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

Pete

On Apr 28, 5:53*pm, Mike wrote:
Pete
It works great! *Thank you, Cheers