Excel Function and Formulas

Question

So I am trying to learn a little more about Excel so I decided to create a character sheet for a Pathfinder character that I had created. In the game there are different levels of currency. Copper Silver Gold and Platinum. If you have 10 copper it equals 1 silver, 100 silver equals 1 gold and 1000 gold equals 1 platinum. In my excel spreadsheet I want it to do all these conversions for me. so if I have 11 copper I want it to subtract 10 from my copper and add the 1 to silver and then leave the 1 copper. and then same with silver gold and platinum. I'm not quite sure what function or formula to use to accomplish this. Any suggestions would be appreciated.

Answer 1

Refer below image:

Formula in cell C2:

=ROUNDDOWN($A$1/(10*100*1000),0)

Formula in cell D2:

=ROUNDDOWN(MOD($A$1,10*100*1000)/(10*100),0)

Formula in cell E2:

=ROUNDDOWN(MOD($A$1,10*100)/10,0)

Formula in cell F2:

=ROUNDDOWN(MOD($A$1,10),0)

Regards,

Amit Tandon