One way:

H2: =IF(DATEDIF(C2,DATE(2008,12,31), "y") < 21, 0, (MIN(E2*0.05,
G2) + MIN(E2*0.03, G2)) / 2)



In article ,
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.
I have tried IF....but I receive an error. Please help!

Thank you for your assistance.