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
This note was uploaded on 06/25/2011 for the course MGSC 290 taught by Professor Johnston during the Fall '09 term at South Carolina.
- Fall '09