View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Diana
 
Posts: n/a
Default I need a formula to help me calculate years of vesting for 401K.

I need a formula that will help me calculate years of vesting for our 401k
plan.
2 years equals 20% vested
3 years equals 40% vested
4 years equals 60% vested
5 years equals 80% vested
6 years and over = 100% vested