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.

 

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

I forgot to mention this has to also be in the round function

 

[John James]

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

 

[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))