Thread
:
calculate years worked by 3% * salary in excel
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Gary L Brown
Posts: n/a
calculate years worked by 3% * salary in excel
=IF(INT(YEARFRAC(starting date,current date))=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?''.
"laurentium3" wrote:
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.
Reply With Quote