This preview shows page 1. Sign up to view the full content.
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
- Fall '09