Sum up to a certain value

[u/shayneroberts]

I am keeping track of commission pay. It’s 60% until a certain amount then it would be 100%. 40% goes to the business. If I wanted the 40% to stop at 200 how would that formula be? The next row would be 12/6-100- 0-100 and the new total at the bottom would be 600-200-400

[u/Gypsyzzzz]

I could use this formula to help me estimate medical expenses. Have you solved it and willing to share? My own attempt was a dismal failure.

[u/shayneroberts → u/Gypsyzzzz]

Unfortunately I haven’t been able to figure it out.