View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
laurentium3
 
Posts: n/a
Default calculate years worked by 3% * salary in excel

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.