Formula to calculate 401(k)
 

Hi
I need to make a formula in the range G13:G45 to calculate the health
insurance cost for each employee by testing whether the name of the
employee's plan in E13:E:45 is equal to the name of the health plan in
cell B4. If it is, then the cost of the health plan is equal to the
value of cell C4; otherwise, the cost is equal to the value of cell
C5.
Thanks in advance
carmelcorn


--
carmelcorn45
------------------------------------------------------------------------
carmelcorn45's Profile: http://www.officehelp.in/member.php?userid=4837
View this thread: http://www.officehelp.in/showthread.php?t=1249949

Posted from - http://www.officehelp.in

Formula to calculate 401(k)
 

carmelcorn45 wrote:
Hi
I need to make a formula in the range G13:G45 to calculate the health
insurance cost for each employee by testing whether the name of the
employee's plan in E13:E:45 is equal to the name of the health plan in
cell B4. If it is, then the cost of the health plan is equal to the
value of cell C4; otherwise, the cost is equal to the value of cell C5.

Put into G13, then copy down through G45:

=if(E13 = $B$4, $C$4, $C$5)

When you copy down, E13 will be changed to E14 etc, but $B$4, $C$4 and
$C$5 remain unchanged.