The scenario is that I want to tip a person x amount of tokens. I want to figure out the cost to get those tokens based on the data in the table in the attached workbook.

Let's create a scenario. Person A I want to tip 1200 tokens to. What would be the least dollar amount to purchase those tokens?

I also have to take into consideration the budget at the time of the purchase. I also need to look at do I want to have left over tokens for a later tip. Also the least amount of purchases is preferable

Say I have $120 to get the 1200 tokens. How can I have Excel figure out the different purchase options for me?

So manually doing it. I can do 2x550 for $99.98 and then 2x50 for $10.98 thus giving me exactly 1200 tokens for the $120 budget. Now 6x200 for 119.94 is more then doing the other purchase option.

Is this even within the scope of using Excel.

I am not very proficient with Excel or even that advanced with math. So if someone can steer me in the correct direction to figure out this problem I would appreciate that.

Attached Files

Tokens.xlsx (8.3 KB, 10 views)