Curtiss Hardware sells battery-powered drills for $99.00 each. If the customer purchases 3 or 4 drills, then the price is reduced to $92 50 each. If the customer purchases 5 or more drills, then the price is reduced to $89.99 each. Sales tax is 10%. 

Create a worksheet that allows the customer (user) to put 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 then calculate the following item:

The total price of the drills purchased before the sales tax. 

The amount of the sales tax. 

The total price of the order includes the sales tax.

You MUST use the IF function to solve Part A.

Answer rating: 100% (QA)

The total price of the drills purchased before the sales tax is 29747 ... View the full answer