1. Use Vlookup to find the hourly rate from the table below B24:D33 (name the range) 2. Use IF function to calculate overtime (over 40 hours is time and half) 3. Calculate Gross pay. 4. Calculate the F and G columns refer to $F$11 and $G$11 5. calculate the net pay= gross less both taxes. 6. Auto sum Lexington Hospital for Special Surgery Payroll Summary For the Week Ending November 16, 2001 1. Use Vlookup to find the hourly rate from the table below B24:D33 (name the range) 2. Use IF function to calculate overtime (over 40 hours is time and half) 3. Calculate Gross pay. 4. Calculate the F and G columns refer to $F$11 and $G$11 5. calculate the net pay= gross less both taxes. 6. Auto sum Lexington Hospital for Special Surgery Payroll Summary For the Week Ending November 16, 2001