Multi-Axis Discount Engine (Category × Tier × Volume)

You're a retail analyst implementing the ops team's new discount engine. The discount is composed from three independent dimensions that multiply together — encoded as nested IF/IFS calls in a single formula.

Columns A–D: Order ID, Product Category (Apparel / Tech / Books), Customer Tier (Gold / Silver / Bronze), Order Size (dollars).

Discount-percentage formula:

final_discount_pct = base_rate × tier_multiplier × volume_multiplier

So an Apparel order from a Gold customer over $500 = 10 × 2 × 1.5 = 30%.

Your task:

1. In column E (Discount %), write a formula that computes base × tier × volume in one cell. The straightforward shape is three IFS calls multiplied together — or wrap with LET for readability.
2. The formula must drag-fill from E2 → E11.

Graded cells: E2 (Apparel/Gold/$800 → 30), E3 (Tech/Silver/$200 → 5), E7 (Books/Gold/$300 → 16).