•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to allocate savings goals, once a bucket hits max, re-allocate remaining funds?
Our take
To effectively manage your savings goals, it's essential to reallocate funds once a specific category reaches its maximum target. In your case, when the oil bucket hits 100%, you'll want to redirect new deposits to the remaining categories that haven't yet met their goals. By using the percentage allocations from column B, you can distribute the remaining funds proportionately across those categories. This method ensures that you're maximizing your savings potential while maintaining the organization and clarity you value.
Hi all,
I'm currently trying to bump up my savings to 6+ months of expenses. I'm trying to hit my goal in each category, that is automatically allocated per the percentage in column B across the board as deposits are made into C12.
However, once the value in E reaches 100%, I'd like to stop allocating to that specific bucket (oil is close) and distribute by the percentage for all categories not at 100% in E, by the percentage in column B across the remaining rows.
How would that be done? (I know, puke pizza for a lot of you. I like keeping it color coordinated.) :)
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#rows.com#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#savings goals#allocation#bucket#expenses#percentage#deposits#categories#100%#distribute#color coordinated#C12#remaining funds#goal#max