Calculate total of tiered payment
Hi all, is there a way to break a number down to make multiple calculations? For example, I am going to pay my sales team based on the number of units they sell. The first 50 units are paid at $20/unit, next 25 units are paid at $30/unit, etc.
In the photo below I want it to automatically calculate the total ($3,250) simply by taking the number of units (110 for Person A) and multiplying it according to the table below it.
Thanks for any help!
Best Answer

Hi @Brad Mulder ,
Try this
=IF(Units@row<=50, units@row*20, IF(Units@row<=75, ((units@row50)*30)+1000, IF(UNITS@ROW<=100, ((units@row75)*30)+1750, ((units@row100)*50)+3000)
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers

Hi @Brad Mulder ,
Try this
=IF(Units@row<=50, units@row*20, IF(Units@row<=75, ((units@row50)*30)+1000, IF(UNITS@ROW<=100, ((units@row75)*30)+1750, ((units@row100)*50)+3000)
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Thanks Mark, that did work as hoped! Much appreciated!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!