Forum Discussion
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.
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.
Some day I hope I have your level of expertise with formulas like that.
As I've said elsewhere on these pages, I'm still learning some of the many features Excel has added since I retired nearly 18 years ago. Especially in the realm of multi-dimensional arrays.
In the meantime, although my approach definitely isn't as elegantly compact as yours (neither the table nor the formula), it's all easier for the average user (or service recipient) to comprehend.