problem solving
Here is my question/setup
In column A i have a list of dollar amounts. In a cell in Column B I have my a speciifc dollar amount i'm looking to extract from column A. My quesiton is: Is there a forumla or solver that can give me the best combination of dollar amounts in column A that would get me closest to the amount in my cell in coumn B, say within 5%? EXAMPLE: In order to get 7, i could use 2+5 or 3+4 (obviously more complicate when using dollarsa & cents) Column A Column B 1 7 2 3 4 5 Thanks! |
All times are GMT +1. The time now is 09:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com