software

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


Try:
=IF(C4lt;1,0,D4*F4) and copy to other cells in column--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=531729
This rounds to 2 decimal places. Is this what you want? Otherwise can
you explain more clearly.

=IF(C4lt;1,0,ROUND(D4*F4,2))--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=531729