如何在Excel中返回到阈值

I'm struggling to solve a calculation problem in Excel which seems to be harder than I thought.. and I just can't find the approach I need on the internet. I will present a simplified version of what I want to get and would be eternally grateful to whoever can help me get the result.I'm struggling to solve a calculation problem i