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

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#progressive compensation
#incremental awards
#tiered payment
#unit thresholds
#award amounts
#formulas
#first tier
#award per unit
#payment structure
#input table
#unit count
#future updates
#compensation model
#threshold adjustment
#financial modeling