Gaming Currency

[erasureutah]

I've tried to search this forum and other forums and Google and blah blah... I have a spreadsheet that I am using to track my crafting and selling of items in Wurm Online. For the life of me, I can't figure out how to convert my irons into Copper and Copper into Silver.
100 irons = 1 Copper
100 Copper = 1 Silver
Silver is max currency.

What I need is anything that goes over 100 to be added to the column to its immediate left. I tried doing it like currency, but I just couldn't work it out. I'm not sure how to do that. I would appreciate any help. See pic below:

 

[BigBeachBananas]

How about this?

Book3
	A	B	C	D
1	Total Collected
2	Silver	Copper	Iron
3	2	100	0	Total
4	3	0	0	Coverted
Sheet2

Cell Formulas
Range	Formula
A4	A4	=A3+INT(B3/100+C3/10000)
B4	B4	=LET(x,B3+INT(C3/100),IF(x>=100,MOD(x,100),x))
C4	C4	=MOD(C3,100)