Need Formula

[sato]

I need a formula to count the value in a cell if it meet a certain date in
another column and for every 3 years I need to add another 5% to the previous
percentage.
For Example:
Date Income
1/1/2010 A*20%
1/1/2013 A*25%
1/1/2016 A*30%

 

[David Biddulph]

=INT((YEAR(A2)-2010)/3)*5%+20% multiply by wherever your value A is.

 

[sato]

It works!!!
Thank you very much David