Question: d . Create a formula in cell H 5 to calculate the taxable pay. Multiply the number of dependents by the deduction per dependent and
d Create a formula in cell H to calculate the taxable pay. Multiply the number of dependents by the deduction per dependent and subtract that from the gross pay. With two dependents, Abram's taxable pay is $ E Use a VLOOKUP function in cell I to identify and calculate the federal withholding tax. With a taxable pay of $ Abram's tax rate is and the withholding tax is $ The VLOOKUP function returns the applicable tax rate, which you must then multiply by the taxable pay. F Calculate FICA in cell J based on gross pay and the FICA rate, and calculate the net pay in cell K
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
