Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|