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

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

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

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

with result formatted as percentage

"Peo Sjoblom" wrote:

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