What is the Microsoft Excel FORMULA that I need to use to calculate percentage of sales?
Rosem123
nicks_order_form.xlsm
Sheet1
| Nick's Sporting Goods |
| 55 Main St. |
| Boston, MA 02134 |
| (217) 555-1234 |
| Order Form |
| Best Selling Products | Quantity | Wholesale Cost | Subtotal | Percentage of Sales |
| Baseball Set | 5 | $24.99 | $124.95 |
| Basketball | 10 | $14.99 | $149.90 |
| Fishing Reel | 8 | $19.99 | $159.92 |
| Golf Clubs | 2 | $239.00 | $478.00 |
| Inline Skates | 4 | $49.00 | $196.00 |
| Mountain Bike | 2 | $249.00 | $498.00 |
| Soccer Ball | 10 | $9.99 | $99.90 |
| Tennis Racket | 8 | $29.00 | $232.00 |
| | | Subtotal | $1,938.67 |
| | | Shipping/Handling | $0.00 |
| | | (5% of subtotal or |
| | | if over $500, free) |
| | | Total | $1,938.67 |
