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

"Diana" wrote:

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