ExcelBanter - 401k formula

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

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

- - 401k formula (https://www.excelbanter.com/excel-worksheet-functions/46020-401k-formula.html)

stacy

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

Myrna Larson

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

All times are GMT +1. The time now is 03:32 PM.