You are thinking of advertising Microsoft products on a popular TV music program. You pay one price for the first group of ads, but as you buy more ads, the price per ad decreases, as shown in the following table.

For example, if you buy eight ads, you pay $12,000 per ad for the first five ads and $11,000 for each of the next three ads. If you buy 14 ads, you pay $12,000 for each of the first five ads, $11,000 for each of the next five ads, and $10,000 for each of the last four ads. Write a formula that yields the total cost of purchasing any number of ads. Hint: You probably need at least three columns in your table range, and your formula might involve two lookup functions.

Transcribed Image Text:

Ad number 1-5 6-10 11-20 21 or higher Price per ad $12,000 $11,000 $10,000 $9,000