An analyst wants to group customers into revenue bands. What is the appropriate calculation design?

1. Define overlapping thresholds without specifying evaluation order
2. Apply a currency format and assume bands appear automatically
3. Use mutually exclusive conditional rules with explicit boundaries and a fallback
4. Use customer names as the numerical threshold