Comprehensive Excel Payroll Example - SUMIFS, MROUND, MOD, VLOOKUP & More

) Introduction.
) Formula for: Hours Worked, using the Functions: SUM, MOD, MROUND.
) Formula for: Total Hours, using the Function: SUMIFS.
) Formula for: Regular Hours, using the Function: IF.
) Formula for: Overtime Hours.
) Formula for: Regular Gross Pay, using the Function: ROUND.
) Formula for: Overtime Gross Pay, using the Functions: ROUND.
) Formula for: Total Gross Pay, using the Functions: SUM.
) Hide Columns.
) Formula for: Cumulative Gross Pay After This Paycheck.
) Formula for: Social Security Deduction, using the Functions: MEDIAN, ROUND.
) Formula for: Medicare Deduction @ 1.45%, using the Functions: MEDIAN, ROUND.
) Formula for: Medicare Deduction @ 2.35%, using the Functions: MEDIAN, ROUND.
) Formula for: Taxable Pay, using the Function: MAX.
) Formula for: Federal Income Tax Withholding, using the Functions: VLOOKUP, ROUND.
) Formula for: Total Deductions.
) Formula for: Net Pay.
) Summary.