Thread: Need Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sato sato is offline
external usenet poster
 
Posts: 5
Default 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



.