I need help with a formula that calculates earnings based on gross commission
with split levels. For example

A gross commission less than 100,000 up to 100,000 makes 50% €¦a gross
commission greater than 100,000 will pay as follows€¦the 2nd 100,000 (100,001
to 200,000 makes 60%...the next 100,000 (200,001 €“ 300,000) makes 70%, so on
and so forth€¦


So with a 400,000 gross commission:

The first 100,000 will pay at 50% = $50,000
The 2nd 100,000 will pay at 60% = $60,000
The 3rd 100,000 will pay at 70% = $70,000
The 4th 100,000 will pay at 80% = $80,000
Total Earnings€¦€¦€¦€¦€¦€¦€¦€¦.$260,000

I need the formula to calculate so that if any of the variables (commission
amounts or split levels) change, the earnings automatically change for all
the individuals.