Excel if statment

Excel Quiz: PAYROLL 30 points Email your work to: [email protected] Due Date: January 14, 2014 at 11:45pm

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