Calculation of Scheme amount with different scheme slab not don't cross that eligible amt

Hello everyone,

I have been feeling quite exhausted lately and I am having trouble finding the right direction. I am hoping that you can help me out.

Let me explain the issue I am facing. Columns E to H contain scheme amounts that are collected under different slabs. Column B contains invoice amounts and the eligibility of benefits should not exceed the invoice amount. This means that the invoice amount is also eligible.

I have provided an example of the expected result in Row 7, but what I am looking for is a formula that combines the Old School method and the New School method to resolve the issue in a single cell.

Thank you for your help.

Sincerely,
Ankur Shukla