Hi all, I am in a college class and this is my first experience with
Excell.

These are the two steps I have been working on for hours and cannot
seem to get right.

1. Insert a formula to calculate to 401k contributions for each
employee.
The formula should determine that if the number of years employed is
great than or equal to 1, then the contribution is equal to the
contributin percentage in cell F4 multiplied by the employees salary;
otherwise, the contribution is 0.

Note: The number of years is cell C12 and employees salary is D12.

2. Enter a formula to calculate the health insurance cost for each
employee by testing wrether the name of the employees plan is equal to
the name of the health plan in cell b4. If it is, then the cost fo the
health plan is equal to the value of cell C4, otherwise, the cost is
equal to the value of C5.

Note: Health plan is cell E12.

Thank you so much for any help or advice offered.


--
brandityler
------------------------------------------------------------------------
brandityler's Profile: http://www.excelforum.com/member.php...o&userid=31418
View this thread: http://www.excelforum.com/showthread...hreadid=511134