Value after specific years.

[jani.pk]

Dear friends,

Please help me with this, In colomn "C" I have mentioned the renevoation year and what I need is that the renovation cost in coloum "E" will be placed according to coloum "C" in that year coloum from F to Y. After the first step the second formula I need is for like i have mentioned in Colonm "D" the next renevoation year and i need that the same renevoation cost will be put in the every year after the coloum"C" value. i have highlighted with yellow colour where i need the value

attached is file for sample.

thankyou all team members for your time and efforts.

[Ace_XL]

In F5

=IF(MOD(F$4-$C5,$D5)=0,$E5,"")

Copy down and across

[jani.pk]

Thankyou ACE.

Really you are a guru.

thankyou brother.

[Ace_XL]

Via PM

Dear friends,
reference to the said thread which you have solve and I have marked it SOLVED therefore I am asking you thru private message. I am facing only one problem in this. whenever I enter year like for instance 2022 in renovation year colmn "C" it will put one value in 2015 and then on 2022 so what I want is it starts from 2022 and then after 7 years it enters again.

please ask me if I fails to explain.

thankyou, appreciated your efforts.

Try...in F5
=IF(AND(F$4>=$C5,MOD(F$4-$C5,$D5)=0),$E5,"")
Copy down and across

[Ace_XL]

Via PM

Dear friends,
reference to the said thread which you have solve and I have marked it SOLVED therefore I am asking you thru private message. I am facing only one problem in this. whenever I enter year like for instance 2022 in renovation year colmn "C" it will put one value in 2015 and then on 2022 so what I want is it starts from 2022 and then after 7 years it enters again.

please ask me if I fails to explain.

thankyou, appreciated your efforts.

Try...in F5
=IF(AND(F$4>=$C5,MOD(F$4-$C5,$D5)=0),$E5,"")
Copy down and across

[jani.pk]

thankyou brother for exceptional help. GR8.