1. esearch the IF Function. Using the following scenarios, PICK ONLY ONE FROM THE BULLETS BELOW and CREATE A SPREADSHEET and attach it to your response to show how you would apply the Excel functions or create a formula to solve the scenario.
o You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost. The IF function will be used to determine the commission.
You MUST use the following headings below in your spreadsheet and input 4 products with Cost and Sales Price.
Commission
Products Cost Sales Price Paid Amount
o You wish to calculate the total pay for an employee who receives regular pay for 40 hours, overtime pay at 1.5 for 41–50 hours, and overtime pay at 2.0 for hours over 50. The IF function will be used for Regular Pay, OT Pay 41-50, and OT Pay >50.
You MUST use the following headings below in your spreadsheet and input 4 employee names, Hrs Worked, and Pay Rate. Under Hrs Worked you will have some hours that are 40 hours or less, some hours greater than 40, and some hours greater than 50.
Hrs Hourly Regular OT Pay OT Pay Total
Employee Worked Rate Pay 41-50 hrs >50 hrs Pay
o You have a list of contracts and due dates for annual maintenance fees. You wish to determine when you have a contract due in the next 45 days and provide a note that warns you that the payment is due.
You MUST use the following headings below in your spreadsheet and input 3 Company names and Contract Due Dates. You will use the IF function to determine if the contract date is due in the next 45 days and provide a warnig that the payment is due.
In Cell A3 enter the word Today
In Cell B3 enter the function =Today()
Here are the headings. You may start in row 5.
Company Contract Due Dates Warning Message
Please feel free to add other, unique mathematical challenge questions to the discussion, and let us work together to figure out how you might calculate it.
