Bob, this is what I used but it is not putting the "0" in...any suggestions???

"Bob Phillips" wrote:

=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.