| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
401k formula
i need a formula that determines :
if # of years employed is greater than or equal to 1, then contribution is equal to percentage multiplied by salary; otherwise contribution is zero |
|
#2
|
|||
|
|||
|
WIth the hire date in A1 and the salary in B1 and the contribution rate 10%
=IF(DATEDIF(A1,TODAY(),"y")=1,B1*10%,0) On Sun, 18 Sep 2005 17:52:02 -0700, "stacy" wrote: i need a formula that determines : if # of years employed is greater than or equal to 1, then contribution is equal to percentage multiplied by salary; otherwise contribution is zero |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simplify formula | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Help! 401k match formula | New Users to Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
Linear Mode
