formula for calculating 401k if over or equal to 1 yr of service .

G

Guest

i am tring to create a fromula to calculate a 401k contrubution if there is
equal to or greater than 1 yr of service the contribution is 3%.
 
B

Biff

Hi!

You haven't provided enough details for a specific
solution so here's my best guess!

You have a starting date in A1 and a salary figure in B1:

=(TODAY()>=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)))*0.03*B1

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need a formula to help me calculate years of vesting for 401K. 2
Calculating a tiered 401k Match 4
formula to calculate a 401K company match? 3
If function 3
IF function 1
If Array EDATE formula help 7
Excel Need Countifs Formula Help 0
401k formula 1

Top