Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what's the formula for finding 401(k)?
How do you find 401(k) because I have a question asking, well saying, insert
a formula to calculate the 401 (k) contributions for each employee. The formula should determine if the years of employed (4.17) is or = to 1, then the contribution is equal to the contribution percentage (3%) multiplied by the employee's salary ($50,000); otherwise, the contribution is zero. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what's the formula for finding 401(k)?
A B C
Years employed Salary 401(k) cont. 4.17 50,000 =IF(A2=1,B2*.03,0) "Manuel H. Cruz" wrote: How do you find 401(k) because I have a question asking, well saying, insert a formula to calculate the 401 (k) contributions for each employee. The formula should determine if the years of employed (4.17) is or = to 1, then the contribution is equal to the contribution percentage (3%) multiplied by the employee's salary ($50,000); otherwise, the contribution is zero. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Help! 401k match formula | New Users to Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |