Remember Me?

#1
November 2nd 06, 03:04 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 1
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.
carmelcorn

--
carmelcorn45
------------------------------------------------------------------------
carmelcorn45's Profile: http://www.officehelp.in/member.php?userid=4837

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

#2
November 2nd 06, 04:26 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 418
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.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Brook6 Excel Worksheet Functions 26 January 30th 07 09:40 PM Tom Excel Discussion (Misc queries) 3 May 2nd 06 08:42 PM Debbie Mack Excel Discussion (Misc queries) 1 September 16th 05 08:37 PM sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM

All times are GMT +1. The time now is 02:12 PM.