View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
spence spence is offline
external usenet poster
 
Posts: 25
Default variable annual wage increases based on start date

I have a five year month-by-month personnel budget with the staff names down
column A and their start dates in columb B. The months and years through 2012
go across row 1.

My question is, is there a way to build formulas that will calculate annual
wage increases based on start date where the increase is:

1. 2% at year one anniversary
2. 3% at year two anniversary
3. 1% at every anniversary thereafter

Thanks.