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)


On Sun, 18 Sep 2005 17:52:02 -0700, "stacy"
wrote:

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