software

If the number of years employed is greater than or equal to 1, then the
contribution is equal to the contribution percentage (3%) * $50,000;
otherwise, the contribution is $0.

=IF(INT(YEARFRAC(starting date,current date))gt;=1,50000*0.03,0)

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;laurentium3quot; wrote:

gt; If the number of years employed is greater than or equal to 1, then the
gt; contribution is equal to the contribution percentage (3%) * $50,000;
gt; otherwise, the contribution is $0.

quot;laurentium3quot; wrote:
gt; If the number of years employed is greater than or equal
gt; to 1, then the contribution is equal to the contribution
gt; percentage (3%) * $50,000; otherwise, the contribution is $0.

Do you really mean quot;3% * salary up to 3% * $50,000quot;?

That seems more consistent with the subject of your posting.
If that is what you mean, then building upon Gary Brown's reply:

=IF(YEARFRAC(hireDate, criterionDate) lt; 1, 0, 3%*MIN(salary, 50000))

You can use TODAY() in place of criterionDate. But that usually
does fit the HR requirements.