The follow table is for use in Problem 4.1.
Item # | Product | Price | After Discount A | After Discount B |
125A | Scooter | $59.99 | ||
789A | Tricycle | $129.95 | ||
78B | Ball | $12.35 | ||
489B | Doll | $21.99 | ||
57B | Art Kit | $14.95 | ||
. | ||||
Discounts | ||||
A | B | |||
10% | 20% |
For the above worksheet, write a formula in the highlighted cell in such a way that
you can fill down and then across to calculate the other prices.
Use Named Cells where appropriate.