Each part must be on a separate worksheet.

Part A and B: You may need to use the AND$/$OR functions in some of your formulas.

Part A:

Curtiss Hardware sells battery powered drills for $$99\mathrm{.}00$ each. If the customer purchases $2,3,$ or

$4$ drills, then the price is reduced to $$95\mathrm{.}00$ each. If the customer purchases $5$ or more drills, then

the price is reduced to $$89\mathrm{.}99$ each. Sales tax is $10\%.$

Create a worksheet that allows the customer $($user$)$ to input the number of drills that they are

purchasing. Pretend that you are the user and input the number of drills that you wish to

purchase.

The worksheet must create an invoice which displays the following items:

The price for a single drill based on the quantity entered by the user.

You MUST use the IF function to determine the price per drill.

The total price of the drills purchased before the sales tax

The amount of the sales tax

The total price of the order including the sales tax

Part B:

Warhawk Company sells two types of computers, Business and Gaming. Business computers sell

for $$599,$ and Gaming computers sell for $$999.$ AUM alumni receive a discount of $$50$ on their

purchase.

Create a worksheet that allows the customer $($user$)$ to input the following two items:

The type of computer they want to purchase $($Business or Gaming$)$

Whether or not they are an AUM alumnus by entering Yes or No

Pretend that you are the customer and input the type of computer that you wish to purchase and

whether or not you are an AUM alumnus.

The worksheet must display the correct price of the computer based on the two user

inputs. $($ignore sales tax$).$ You must determine the price of the computer by using an IFS

function.

Create a nested formula in a single cell using IFERROR and IFS so that if the IFS

function results in an error, then the cell displays "Error! Please reenter your inputs."

You should have two formulas when you are done that each determine the correct price; one that

uses IFS and one that uses IFERROR and IRS.