I need a formula to help me calculate years of vesting for 401K.

[Diana]

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

 

[Peo Sjoblom]

One way, with the years in A1


=IF(A1="","",LOOKUP(A1,{0;2;3;4;5;6},{0;0.2;0.4;0.6;0.8;1}))


format result as percentage



Regards,


Peo Sjoblom

 

[Toppers]

With years in A1 (assumes there is an entry):

=IF(A1>=6,1,(A1-1)*0.2)

with result formatted as percentage