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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!