401k Match
On May 15, 1:00*pm, KristiM wrote:
I am trying to create a formula that will create the following:
*Column E Compensation, Column G Emp contribution, and
C Date of birth mm/dd/yyyy. The match 100% of 1st 3% and
50% of next 2% No match over 4%. *Also no match
if employee is under 21 *of age at 12/31/08.
Does the following work for you:
=if(datedif(C2,date(year(today()),12,31),"y") < 21, 0,
min(G2,E2*3%) + 50%*max(0, min(G2-E2*3%,E2*2%)))
I took the liberty of assuming you really want to calculate age based
on the end of the current year, not always 12/31/2008. Also, I assume
you mean no match over 5% (3% + 2%).
|