Enter a lookup function in cell E5 that returns the tax deduction amount for the number of dependents listed in the cell C5. Use the table in range H13:I17 to complete the function. The maximum deduction is $500.00; therefore, employees with more than four dependents will
receive no additional deductions.

Beta Manufacturing Emplayee Withholdings Employee ID Status Dependents Salary 90,212 Deduction Withholding Statistics 7276 FT Number of FT Employees 13 9858 PT 18,984 Average Salary Full Time $ 67,950.77 8936 FT 42,906 Additional Information Average Salary of FT>-1 Dependent 6881 FT 37,191 3852 FT 52,528 6580 PT 17,126 65,771.58 4772 FT 94,101 4296 PT 12,471 Dependents Deduction 8884 FT 67,132 50.00 9916 FT 88,604 125.00 5803 FT 55,680 250.00 8708 FT 98,869 325.00 SS6S PT 11,994 SO0.00 6142 PT 17,957 FICA Withholdings FT at least 1 Dependent B164 FT G6,693 4338 FT 84,432 5833 PT 18,994 PT or FT No Dapendents 5% 6060 FT 65,648 2559 PT 18,835 5569 PT 15,525 Employee ID Status Dependents Salary Deduction Withholdings 3488 PT 15,861 ET 7353 PT 16,173 4990 PT 9,893 4785 PT 17,081 3040 FT 39,364 B087 PT 19,306 4474 PT 9,933 4251 PT 16,707 %3B