401k formula

S

stacy

i need a formula that determines :
if # of years employed is greater than or equal to 1, then contribution is
equal to percentage multiplied by salary; otherwise contribution is zero
 
M

Myrna Larson

WIth the hire date in A1 and the salary in B1 and the contribution rate 10%

=IF(DATEDIF(A1,TODAY(),"y")>=1,B1*10%,0)
 

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

401 k formula 7
what's the formula for finding 401(k)? 1
calculate years worked by 3% * salary in excel 2
If function 3
IF function 1
HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
formula for calculating 401k if over or equal to 1 yr of service . 1
Calculating a tiered 401k Match 4

Top