401 k formula
 

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.

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

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.

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

--
HTH

Bob Phillips

"stacy" wrote in message
...
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.

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

"Bob Phillips" wrote...
Then surely that suggest that C5 is greater or equal 1?

"stacy" wrote ...
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)

No, the years employed is like 0.88...

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

"stacy" wrote in message
...
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.

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???

"David McRitchie" wrote:

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

"Bob Phillips" wrote...
Then surely that suggest that C5 is greater or equal 1?

"stacy" wrote ...
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)

I figured it out....Thanks!

"stacy" wrote:

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???

"David McRitchie" wrote:

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

"Bob Phillips" wrote...
Then surely that suggest that C5 is greater or equal 1?

"stacy" wrote ...
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)