Excel and Business Math - VLOOKUP and MAX Functions for Percentage Method Federal Income Tax Deduction

) Introduction.
) Federal Income Tax Withholdings Deducted from Employees Paychecks.
) IRS web site with 2018 Percentage Method Tax Tables..
) 2018 Percentage Method Federal Income Tax Withholding Tables in Excel.
) Video Example 1: Calculate Federal Income Tax Withholdings for Marital Status “Single” and Pay Period Weekly. Calculations made by Hand and with MAX and VLOOKUP..
) Use Formula Evaluator to verify that VLOOKUP Formula is working correctly.
) Video Example 2: Calculate Federal Income Tax Withholdings for Marital Status “Married” and Pay Period Weekly. Calculations made by Hand and with MAX and VLOOKUP..
) Video Example 3: Calculate Federal Income Tax Withholdings for Marital Status “Single” and Pay Period Weekly for an Entire Payroll Table. Calculations made with MAX and VLOOKUP..
) Video Example 4: Calculate Federal Income Tax Withholdings for Marital Status “Married” and Pay Period Weekly for an Entire Payroll Table. Calculations made with MAX and VLOOKUP. See how to copy a Whole Table for formulas to a new template..
) Summary.