I am trying to create a formula for a budget.
example:
I have a daily budget of $20
I also have a weekly budget of $100

So If I spend more than $20 in a day I want the amount subtracted from the $100 weekly budget. But I don't want the remainder added to the weekly budget.

So if on Monday I spent $40, the weekly amount would show $80, On Tuesday I spent $10 the weekly would still show $80.

So the weekly amount never increases, it only decreases if the daily budget goes into negative numbers.