ExcelBanter - formula for calculating 401k if over or equal to 1 yr of service .

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula for calculating 401k if over or equal to 1 yr of service . (https://www.excelbanter.com/excel-worksheet-functions/19022-formula-calculating-401k-if-over-equal-1-yr-service.html)

thomas

formula for calculating 401k if over or equal to 1 yr of service .

i am tring to create a fromula to calculate a 401k contrubution if there is
equal to or greater than 1 yr of service the contribution is 3%.

Biff

Hi!

You haven't provided enough details for a specific
solution so here's my best guess!

You have a starting date in A1 and a salary figure in B1:

=(TODAY()=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)))*0.0 3*B1

Biff

-----Original Message-----
i am tring to create a fromula to calculate a 401k
contrubution if there is
equal to or greater than 1 yr of service the contribution
is 3%.
.

All times are GMT +1. The time now is 06:45 AM.