PAYROLL
Assume you work for the payroll department and your boss asks you to create a spreadsheet that
will compute the total weekly salary for his employees. Employees are paid on a regular basis if
they work 40 hours or less per week and as follow if they work over-time:
1. If the job status of an employee is Full Time then the employee is paid at an overtime rate of
double-time
Example 1: If an employee is Full Time and the regular hourly rate is $10, then the over-time
rate is $20 dollars.
1. If the job status of an employee is Part Time then the employee is paid at an over-time rate
of Time and a half.
Example: If an employee is Part-Time and the regular hourly rate is $10, then the over-time
rate is $15 dollars.
YOUR TASK
Create a spreadsheet that allows a user to enter the hours worked per day.
The spreadsheet should display and calculate:
1. The Total Hours worked
2. The Total Salary (Regular + Over-Time wages earned if any)
3. Note that changing the value in cell B9, causes the Total Salary to recalculate
You must use the
nested IF
statements
To calculate the
Total Salary