Hello Wrenn and Welcome to Excel forum.
Here is a proposed formula solution that employs a helper column, where the initial value in Q15 is 4 (assuming 20 gold coins = 4 platinum coins).
The formula for the helper column, starting with row 16, is:
Formula:
=Q15-SUMPRODUCT(Table_1[@[Withdrawal,Payment (CP)]:[Withdrawal,Payment (PP)]],0.001,0.01,0.1,0.2,1})+SUMPRODUCT(Table_1[@[Deposit,Credit (CP)]:[Deposit,Credit (PP)]],{0.001,0.01,0.1,0.2,1})
The formula for the Balance (PP) is: =IF(ROUNDDOWN(Q15,0)>=0,ROUNDDOWN(Q15,0),0)
The formula for the Balance (GP) is: =IF(ROUNDDOWN((Q15*10-P15*10)/2,0)>=0,ROUNDDOWN((Q15*10-P15*10)/2,0),0)
The formula for the Balance (EP) is: =IF(ROUNDDOWN((Q15-(P15+O15*0.2))*10,0)>=0,ROUNDDOWN((Q15-(P15+O15*0.2))*10,0),0)
The formula for the Balance (SP) is: =IF(ROUNDDOWN(ROUND(Q15-(P15+O15*0.2+N15*0.1),3)*100,0)>=0,ROUNDDOWN(ROUND(Q15-(P15+O15*0.2+N15*0.1),3)*100,0),0)
The formula for the Balance (CP) is: =ROUNDDOWN((Q15-(P15+O15*0.2+N15*0.1+M15*0.01))*1000,0)
Let us know if you have any questions.
Bookmarks