Forum Discussion
i need help if its possible. currency creator
im trying to get a formula together to help me with tracking my currency on my first dnd campaign. i have a formula that helps for a standard format however the campaign that im in has a bit of a different currancy system.
its measured in copper silver and gold and the standard metric is that
100 copper = 1 silver, 100 silver = 1 gold, this formula that i have does this for me by giving me a custom currency
[<100]#"c";[>10000]#"g "##"s "##"c";#"s "#"c";
but for the campaign that im in its
10 copper = 1 silver, 10 silver =1 gold. and for the life of me i cannot work out or find anything that can do this for me.
please if anyone kons how to do this then could you please help.
12 Replies
First, I'm not sure why it is that you can make that first formula work, but not the second, since it's just a difference of a factor of 10.
That said, your first formula doesn't appear to be any recognizable (at least not recognizable by me) Excel formula. If you actually have a spreadsheet where that's working, please share it. That way we can help you without having to read your mind.
Second, are there units of currency that reflect fractions of these different metals, much as our quarters or dimes or nickels represent 1/4, 1/10th and 1/20th of a dollar (which at one time reflected a certain number of ounces of silver)?
Said another way, how do you receive or spend this currency? What, other than figuring out the relationship between x amount of copper and the relevant amounts of silver or gold, are you tracking or using?
Said another way, give a bigger picture here of how this is fitting in to some larger context.
I'm sorry, but you don't say where that "custom currency section" is, and there's no section so labelled (as this image shows)
I did find a formula in cell B26 of "Sheet1" that converts the number in the cell above it to the format you are referring to, but haven't found it referenced in any other cells. It may be that the formula in that cell is the one needing to be changed.....
Are you thinking that DnD is something everybody has experience with?
I'd be happy to help, but you need to provide greater clarity in what is and what is not working.
