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)
 
Top