View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trish
 
Posts: n/a
Default formula to calculate a 401K company match?

The company I work for will match employees 401K with the following: The
first 3% the company matches 100%, the 4th and 5th % the company will match
50%. Does anyone know a formula that will calculate this, I need to figure
this semi-monthly.