| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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%. |
|
#2
|
|||
|
|||
|
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%. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set a formula in a cell to equal the total in another ce. | Excel Worksheet Functions | |||
| PPMT formula that generates equal payments | Excel Worksheet Functions | |||
| Help! 401k match formula | New Users to Excel | |||
| why does Equal sign not appear on the formula bar | Excel Discussion (Misc queries) | |||
| why does Equal sign not appear on the formula bar | Excel Discussion (Misc queries) | |||
Linear Mode
