Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old 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
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


  #2   Report Post  
Old 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
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 01:05 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017