# Formulas for multiple savings goals with limits and overflows

Occasional Visitor

# Formulas for multiple savings goals with limits and overflows

Hello,

I am trying to create a tracker for my savings account that lists multiple categories (goals) and automatically calculates my progress whenever I add money to that account. This is what I'm trying to accomplish:

I want each goal (C5:8) to calculate a percentage of the "ending savings" amount that does not exceed the goal amount to the right (=min formula). But once a goal reaches its limit there will be a remainder that won't be calculated into the other categories since they have a set percentage amount as well, right? I need to find a way that limits a cell to the goal number, but then "sends" whatever remainder that cell calculates to another category. Is that possible? Let me know how I can clarify better