A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Formula to calculate 401(k)



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

Ads
  #2  
Old November 2nd 06, 04:26 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 418
Default 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

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

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 07:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.