Calculating 401k Company Match up to 6%

Ok all, I am a noob to this site! I have a problem and was wondering if any of you Excel masters can help out. I have a spreadsheet and I need to calculate the 401k the company matches up to 6%. Here is an example:

If yearly salary = $50,000 and I vest 8% of my salary then I have vested $4,000 into my 401k. The company will match up to but not more than 6% of what my 401k percentage therefore in this example they will match 6% of $50k = $3,000

So if I have 4 columns:

A = Yearly Salary
B = My 401k vestment
C = Employer 401k match (up to but not more than 6%)
D = 401k Percent vesting

How would the equation be formulated for cell "C"?

Thanks for any help.

Sincerely, T

Ok all,

This is what I came up with. Check this to see if this is written efficent enough:

=IF(D2<=0.06,A2*D2,IF(D2>0.06,A2*0.06))

...of course the first row has the header information:
A1 = "Total Compensation"
B1 = "Employee 401k Vestment"
C1 = "Employer Match"
D1 = "Actual %"

...it seems to work

...more input is welcome!

This may work. The parentheses may not be in the right place. I'm on a computer without Excel right now but you can use the insert function and enter the equations. This says that if your total investment is greater than 6% then the company will match the total 6%. Otherwise, they will match whatever you invest under the 6% of your total investment.

IF (B1> (.06*A1),(.06*A1),B1)