Formula for Retirement % in graduating levels

Since I do not understand this formula,I am asking for help. The payroll software has this formula:

min((d(401K STR)/2),(grosspay*.02))

What does the "min((d(" mean?

I can figure out the "401K STR" - that's the traditional contribution by the employee

I know the "grosspay" is multiplied by the 2%


I am guessing I have to set up six formulas unless someone know how to combine the following. ??

If employee contributes 1% of gross pay then the employer match is 1%
If employee contributes 2% of gross pay then the employer match is 1.5%
If employee contributes 3% of gross pay then the employer match is 2%
If employee contributes 4% of gross pay then the employer match is 2.5%
If employee contributes 5% of gross pay then the employer match is 3%
If employee contributes 6% of gross pay then the employer match is 3.5%
And all above % are limited to 3.5%

Thank you for taking the time to read this. I am over my head for this and appreciate anyone who is knowledgeable to help me.
GowerGirl

This is the formula in the cell:

=min((d(401K STR)/2),(grosspay*.02))

What I posted was copied out of the cell in the "ComputerEase" payroll software. I am going to contact the software company.

Can you give me a formula that I can use in an excel document?

Like if Gross Income is $50,000. then the amount that is 6% (employee contribution)of gross pay and then another cell that has 3.5% (employer match)?
And what would the formula be if the employee contribution is over 10% but can the employer mat cannot exceed 3.5%?

Thank you so much for your time and explanation.

Have to catch the reply on Monday.

Gower Girl