Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Formula won't calculate... | Excel Discussion (Misc queries) | |||
Formula to calculate over-time | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |