![]() |
#2
|
||||
|
||||
![]()
Given that you haven't even decided whether you want to keep unused tokens for a future trip, this isn't something Excel can solve. Even if you don't, it may sometimes be cheaper to buy more tokens than the exact number you need. There may also be more than one solution.
Your example of 200 tokens @ $19.99 each = $119.94 is certainly not the best you can do in that instance. You could even buy 1300 tokens for less (900 @ $74.99 + 200*2 @ $19.99 = $114.97) and, if you wanted 100 tokens for something else, that might be the way to go. Alternatively, there are at least two ways of getting exactly 1200 tokens for $105.96: 900 @ $74.99 + 200 @ $19.99 + 90 @ $9.49 + 10 @ $1.49 900 @ $74.99 + 200 @ $19.99 + 50*2 @ $5.49 PS: Instead of posting links to workbooks you've loaded elsewhere, you can attach files here, so people don't have to go looking elsewhere. That gives you a better chance of getting an answer. I've replaced your link with a workbook containing the same data.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculating the cost of an investment | lynchbro | Excel | 0 | 06-11-2015 08:26 AM |
New Cost columns are not summing up. | elvanaguven | Project | 3 | 11-08-2014 02:28 PM |
Cost of Investment with assumptions | lynchbro | Excel | 0 | 06-25-2014 04:07 PM |
![]() |
Steve. | Project | 7 | 05-14-2014 06:28 AM |
How to rename cost column | ketanco | Project | 3 | 06-15-2012 03:06 PM |