Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hi all, I am in a college class and this is my first experience with Excell. These are the two steps I have been working on for hours and cannot seem to get right. 1. Insert a formula to calculate to 401k contributions for each employee. The formula should determine that if the number of years employed is great than or equal to 1, then the contribution is equal to the contributin percentage in cell F4 multiplied by the employees salary; otherwise, the contribution is 0. Note: The number of years is cell C12 and employees salary is D12. 2. Enter a formula to calculate the health insurance cost for each employee by testing wrether the name of the employees plan is equal to the name of the health plan in cell b4. If it is, then the cost fo the health plan is equal to the value of cell C4, otherwise, the cost is equal to the value of C5. Note: Health plan is cell E12. Thank you so much for any help or advice offered. -- brandityler ------------------------------------------------------------------------ brandityler's Profile: http://www.excelforum.com/member.php...o&userid=31418 View this thread: http://www.excelforum.com/showthread...hreadid=511134 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The 401K formula is =IF(C121,D12*F4,0)
and the health plan formula is =IF(E12=B4,C4,C5) -- Kevin Backmann "brandityler" wrote: Hi all, I am in a college class and this is my first experience with Excell. These are the two steps I have been working on for hours and cannot seem to get right. 1. Insert a formula to calculate to 401k contributions for each employee. The formula should determine that if the number of years employed is great than or equal to 1, then the contribution is equal to the contributin percentage in cell F4 multiplied by the employees salary; otherwise, the contribution is 0. Note: The number of years is cell C12 and employees salary is D12. 2. Enter a formula to calculate the health insurance cost for each employee by testing wrether the name of the employees plan is equal to the name of the health plan in cell b4. If it is, then the cost fo the health plan is equal to the value of cell C4, otherwise, the cost is equal to the value of C5. Note: Health plan is cell E12. Thank you so much for any help or advice offered. -- brandityler ------------------------------------------------------------------------ brandityler's Profile: http://www.excelforum.com/member.php...o&userid=31418 View this thread: http://www.excelforum.com/showthread...hreadid=511134 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() thank you so much for your help, however the first formula, i copied and pasted both, gives me the word value and second formula does give me a number like its supposed to but its the wrong number, i get 5500 but im supposed to get 7000. am i doing something wrong or is the formula wrong? thanks again. -- brandityler ------------------------------------------------------------------------ brandityler's Profile: http://www.excelforum.com/member.php...o&userid=31418 View this thread: http://www.excelforum.com/showthread...hreadid=511134 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() thank you so much for your help, however the first formula, i copied and pasted both, gives me the word value and second formula does give me a number like its supposed to but its the wrong number, i get 5500 but im supposed to get 7000. am i doing something wrong or is the formula wrong? thanks again. -- brandityler ------------------------------------------------------------------------ brandityler's Profile: http://www.excelforum.com/member.php...o&userid=31418 View this thread: http://www.excelforum.com/showthread...hreadid=511134 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
For your first formula, check that you have numbers in cells D12 and F4
and not text values that look like numbers. To investigate the second formula, check what values you have in cells E12, B4, C4 and C5. Hope this helps. Pete |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() i was not entering the absolute references. thank you so much!!!! -- brandityler ------------------------------------------------------------------------ brandityler's Profile: http://www.excelforum.com/member.php...o&userid=31418 View this thread: http://www.excelforum.com/showthread...hreadid=511134 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |