If function
 

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.

If function
 

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

If function
 

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


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531729

If function
 

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


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531729