IF_Hobby_Company

# IF_Hobby_Company - not the number zero is put into the...

This preview shows page 1. Sign up to view the full content.

My Favorite Hobby Company [Student Name], Manager Columbia, SC Customer Product Current Pr Units SoldTotal Sale Amount of Discounted Sales Tax Amount Due Outback Dremel Del 109.99 5 North ArcticHobbyPro A 59.99 25 Harry's Hob Dremel Del 63.95 5 Julies's Jub X-Acto Knif 15.95 20 Jerry's Woo Dremel Mul 169.99 45 Beaurigard' Dremel Del 63.95 15 Sports Attitu X-Acto Knif 15.95 50 Discount Th 1,000.00 Number of Customers: Discount Pe 15% Highest Current Price: Sales Tax: 6.5% Fewest Units Sold: Average Discount: Total Amount Due: Complete the remainder of this spreadsheet with formulas and functions. > Total Sale = Current Price x Units Sold > Amount of Discount must be solved using the IF function to determine a customer's discount by (1) determining if the Total Sale is greater than or equal to the Discount Threshhold. (2) If it is, the Total Sale amount is multiplied by Discount Percentage and put into the cell. (3) If it is
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: not, the number zero is put into the cell. > Discounted Amount = Total Sale - Amount of Discount > Sales Tax = Discounted Amount x Sales Tax percentage > Amount Due = Discounted Amount + Sales Tax > Number of Customers can be determined using the function COUNTA on the range of Customer names in column A. > Highest Current Price must be calculated by using the MAX function on the range of Current Prices. > Fewest Units Sold requires the MIN function be applied to the range of units sold. > Average Discount is the AVERAGE (function) of the range of discounts. > Total Amount Due should be calculated by using the SUM function on the range of Amounts Due....
View Full Document

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern