Thread: problem solving
View Single Post
  #1   Report Post  
ClayTele
 
Posts: n/a
Default 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!