If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Formula to calculate 401(k)
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Formula to calculate 401(k)

#1
November 2nd 06, 03:04 PM posted to microsoft.public.excel.worksheet.functions
 carmelcorn45 external usenet poster 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 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 Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Find value in array Brook6 Excel Worksheet Functions 26 January 30th 07 09:40 PM Formula won't calculate... Tom Excel Discussion (Misc queries) 3 May 2nd 06 08:42 PM Formula to calculate over-time Debbie Mack Excel Discussion (Misc queries) 1 September 16th 05 08:37 PM Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM

All times are GMT +1. The time now is 04:03 AM.