If function

[potsie]

I have a new problem, how do I type the If formula for this one
the formula is to calculate 401K contributions for employees. The formula
should determine the number of years employed in column C is greater than or
equal to 1, then the contributions is equal to the contribution percentage of
3% located in column F4 multiplied by the employee salary in column D,
otherwise the contribution is zero.

[John James]

Try:
=IF(C4<1,0,D4*F4) and copy to other cells in column

[potsie]

potsie wrote:
>I have a new problem, how do I type the If formula for this one
>the formula is to calculate 401K contributions for employees. The formula
>should determine the number of years employed in column C is greater than or
>equal to 1, then the contributions is equal to the contribution percentage of
>3% located in column F4 multiplied by the employee salary in column D,
>otherwise the contribution is zero.
I forgot to mention this has to also be in the round function

[John James]

This rounds to 2 decimal places. Is this what you want? Otherwise can you explain more clearly.

=IF(C4<1,0,ROUND(D4*F4,2))