Need Formula
 

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%
--
sato panago

Need Formula
 

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


"sato" wrote in message
...
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%
--
sato panago

Need Formula
 

It works!!!
Thank you very much David
--
sato panago


Ο χÏ�ήστης "David Biddulph" Î*γγÏ�αψε:

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


"sato" wrote in message
...
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%
--
sato panago


.