One way:

A1: Salary
B1: % contributed
C1: =(MIN(B1,3%)/2 + MIN(B1,5%)/2) * A1


In article ,
JK wrote:

Hello,

I need to create a formula that will calculate a tiered 401k match based
upon the amount being contributed.

The match formula is 100% on the first 3% of an employee's contribution, and
50% on the next 2% contributed.

The columns I have are 1) Salary, 2)Percent contributed.

Any and all help is greatly appreciated.