Production cost calculator with variable price depending on quantity

The accepted IF formula works well for the current 1–9 batch requirement. If the pricing rules become more complex, though, I’d probably avoid adding more nested IF statements.

A small lookup table for quantity ranges and their corresponding discount could make the calculator much easier to maintain. Then the formula only needs to find the appropriate tier, so changing the pricing rules later wouldn’t require rewriting the calculation.

For example, the table could contain minimum quantity, maximum quantity, and discount percentage. This also makes it easier to extend the calculator beyond 9 batches or add different pricing rules for different products.