1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Need formulas to model progressive incremental compensation awards

I have a table for inputs you can reference below.

I need to be able to update this in the future for unit thresholds and award amounts.

The first tier will be paid at the tier 1 award of $800 per unit (for the first 5 units), the next tier (next 5 units) will be paid at an award of $1200 per unit, etc.

Table in comments. TYIA

submitted by /u/no_rest_for_the
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article