I was provided with the following formula to calculate qtrly match:
=IF(DATEDIF(C2,DATE(YEAR(TODAY()),12,31),"y")<21,0 ,G2*MIN(D2,3%)+50%*MAX(0,MIN(G2*3%,D2*2%))).
The problem is that this formula is not calculating the correct amount for
anything over 4%. Match is 100% of the first 3% and 50% of the second 2%, so
if contribute 5% we only match 4% (3%(100%) + 1%( 50%- 2%)
Example: John contributes 10% 1st qtr amt $1514.43= $60.58. The formula
shown above calcs $45.43. What am I doing wrong?