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.

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.