Computer Game Trading Calculator

[sunsoar77]

Hi there,

Currently playing Guildwars 2 and there is an in-game trading post where you can sell surplus equipment. You can also, if you can find the right niche, make money by buying low and selling higher.

I currently have an app that helps me with individual trades, but I don't have a way of tracking my purchases/sales and their values. In game currency is Gold, Silver, Copper. With 100 copper = 1 silver, 100 silver = 1 gold. All the trading values are broken into gold silver copper values and I'd like it to look the same in my tracker instead of trying to figure out the 'raw' copper values which I can get to work.

I've tried a few formula's and I can get them to work for smaller amounts (usually less than 10 or 20 gold), however my formulae aren’t scaling with the value of the purchase.

I've mainly been attempting to use MOD/ROUNDDOWN/TRUNC functions after calculating a total in copper and dividing as appropriate.

I've attached what I want the sheet to look like - would appreciate any assistance!

goldsilvercopper.xlsx