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