Unused tokens would be kept for future tips as it would reduce the outlay for the next tip.

So based on what I am reading here this is out of the scope of Excel?

There is no way to tell Excel to figure out different combinations of token purchase to add up to the amount I want to tip from that list.

Sorry about the link. I didn't think it would be an issue. I will keep that in mind if I have to link another sheet.