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

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