Thread: 401k Match
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KristiM KristiM is offline
external usenet poster
 
Posts: 12
Default 401k Match

I am trying to create a formula that will create the following: Column E
Compensation, Column G Emp contribution, and C Date of birth mm/dd/yyyy.
The match 100% of 1st 3% and 50% of next 2% No match over 4%. Also no match
if employee is under 21 of age at 12/31/08.
I have tried IF....but I receive an error. Please help!

Thank you for your assistance.