MONEY SPREADSHEET that splits amount by percentage

[spencer695]

Hi, I am looking to create a spreadsheet where I can input amounts weekly/monthly, but although I would like to see the running total, I am after for the total to be broken down into three separate amounts of that total. i.e. 50% 45% and 5%.

So week 1 input 1000 - pot 1 = 500, pot 2 = 450, pot 3 = 50
week 2 input 800, so now pot 1 = 900, pot 2 = 830, pot 3 = 70. Total 1800. and so on.

But then, if an amount is removed, I need it to removed from pot 2.

So, week 3 output 200. pot 1 = 900, pot 2 = 630, pot 3 = 70. Total 1600.

So any input is split as per the percentages in each pot, but then any output is only taken from pot 2 amount and not effecting pot 1 and 3.

Hope this makes sense and thanks in advance.

[JohnTopley]

Please see yellow banner at top of page on how to attach a sample workbook

[AliGW]

Is this the sort of thing you mean?

AliGW on MS365 Insider (Windows) 64 bit

	B	C	D	E	F	G
4	Credit	Debit	Pot 1	Pot 2	Pot 3	Total
5	1000		500	450	50	1000
6		300		-300		-300
7	300		150	135	15	300
8		500		-500		-500
9		-300		300		300
10	Totals		650	85	65	800

Sheet: Sheet1

AliGW on MS365 Insider (Windows) 64 bit

	D	E	F	G
5	=IF([@Credit]="","",[@Credit]*50%)	=IF([@Debit]<>"",-[@Debit],IF([@Credit]="","",[@Credit]*45%))	=IF([@Credit]="","",[@Credit]*5%)	=SUM(Table1[@[Pot 1]:[Pot 3]])

Sheet: Sheet1