Re: Operation Pitchfork Physical Edition Coins
#####
Reply #65 –

Okay, I just finished getting a column for each individuals personal total into the copy of the doc I downloaded. Is it too early to integrate it into the online one? I know we still need more pricing info for it to be complete but it will update as the new information is added.

Link to modified document if you want to play around with it or add the formula to the main doc.

https://www.dropbox.com/s/sxm6u744scei2se/Pitchfork_Coins_Modified.xlsxWhat the formula does.

If the row has nothing in either the coins or paperweights column return blank text.

If the row has nothing in the coins column and the cost per paperweight is $0.00 return blank text.

If the row has nothing in the coins column and the cost per paperweight is non-ero return number of paperweights time cost per paperweight plus extra donation.

If the row has nothing in the paperweights column return number of coins times current cost per coin plus extra donation.

If the row has entries in both columns return number of coins times current cost per coin plus number of paperweights time cost per paperweight plus extra donation.

~~I'm aware that there is an oversight in that a row with only an extra donation will return blank text, I figured the likelihood of that happening was low. If you want the formula in the doc and covering that eventuality I can work on it some more tomorrow.~~Never mind, I thought of a really simple solution. The formula will now return the value of the extra donation if nothing else is present, and only return blank text when all three columns are blank.