Tiered Calculation Formula Help

mathetes Capping fees may not be common in financial services industry. But that's not my area of expertise 🙂

When applying these kind of calculations to employee incentive plans, for example, it's quite common in the industries I've worked in (in Europe, that is), that such incentives aren't unlimited but capped at a number of times of target incentives. Obviously, the rates table will look "slightly" different as the incentive rate usually goes up for incremental revenues/order intake (or whatever the basis may be for the incentive).

Anyhow, just wanted to demonstrate that you can do these kind of calculations in one single formula with one helper column that holds the differential rate from the current to previous tier.