I have a couple questions that I do not understand on my computer homework.
- I have to use the VLOOKUP function in cell I5 to identify and calculate the federal withholding tax. How do I calculate the tax?
- I have to calculate a FICA in cell J5 based on gross pay and the FICA rate, and calculate the net pay in cell K5. How do I calculate this for Cell J5?
In order to calculate the tax rate, you will use the VLOOKUP function in the table with Taxable Pay and... View the full answer