Trying to calculate Qtr 401k mtch. Mtch is 100% of the first 3% of deferred
compensation and 50% of the next 2%. D: Defer %, E: Salary, F: Deferred
Amount

=IF(DATEDIF(C2,DATE(YEAR(TODAY()),12,31),"y")<21,0 ,(MIN(E2*0.04,F2) +
MIN(E2*0.03, F2)) / 2)

Example: Ann elects 1% total deducted is 180.02. Qtr Match is 180.02

Pleas help!