r/excel•
Djjmax

attempting to make a sum of a video game currency, struggling to make the proper if statement

solved

the game I play uses a tiered currency 100 copper makes a silver, 100 silver makes a gold. I am attempting to make a total cash earned where multiple instances of sales are summed up like so http://imgur.com/0BzNQvq the total cash of each column is being put into the highlighted cells. and then the "T. gold, T. Silver, and T. copper" fields are SUPPOSED to be edited from there, what I WANT to happen is whenever a lower tier reaches 100, it falls back down to zero, and the next tier gains one ie if I had 3 gold and 99 silver, then 1 silver gets added I would have 4 gold, 0 silver. I was able to make this happen, but it only worked once. so what i want to know is how to make this happen across all three columns, where if copper reaches 100, the silver is increased by one and the copper is reset. and if silver reaches 100, then gold is increased by one and silver is reset. I was able to make the currency reset, but not get the adding one to the next tier to work properly.

Posted Apr 1, 2016, 10:14 PM UTC · edited

36
Loading comments…