Thread: 401 k formula
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

=IF(C5=1,D5*D2,0)

--
HTH

Bob Phillips

"stacy" wrote in message
...
if # of years employed is in C5, salary is in D5, percent to contribute is

in
D2...I need a formula that determines...IF number of years employed is
greater than or equal to one then the contribution is equal to the percent
multiplied by the salary; otherwise the contribution is zero.