401 k formula

[stacy]

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.

 

[Bob Phillips]

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

 

[stacy]

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

 

[Bob Phillips]

Then surely that suggest that C5 is greater or equal 1?

 

[David McRitchie]

Or perhaps zero values is not checked in options:
Tools, Options, View, [x] zero values

 

[stacy]

No, the years employed is like 0.88...

Then surely that suggest that C5 is greater or equal 1?

 

[stacy]

Ok guys, this is the formula I used =IF($C$13>=1,D13*$F$4,0) and it is not
giving me a zero in my less than a year cells....do I not need to use
absolute reference???

Or perhaps zero values is not checked in options:
Tools, Options, View, [x] zero values

Then surely that suggest that C5 is greater or equal 1?

 

[stacy]

I figured it out....Thanks!

Ok guys, this is the formula I used =IF($C$13>=1,D13*$F$4,0) and it is not
giving me a zero in my less than a year cells....do I not need to use
absolute reference???

Or perhaps zero values is not checked in options:
Tools, Options, View, [x] zero values

Then surely that suggest that C5 is greater or equal 1?

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)