number. Copy this formula to $H4$:$H6.$

$8.$ Airline tickets are assigned a fare category based on the base fare ticket price $($column $G)$ and the categories listed on the Fees worksheet. In cell $13,$ write a formula using named cells and ranges that determines the fare category for this ticket. Copy the formula to cell $14$:$16.$