Thanks JoeU2004 & Dana DeLouis~

Dear Dana DeLouis,
Thanks for your sharing and remind for the mutiple answer issue.
BTW, how do you get those answers?!

Is there any ways to list out all possible answers?!
I just read your post - Subject: all possible combinations
(but seems this is not the same thing right?)

Stan

"Dana DeLouis" wrote:

eg ($1165= 275*3 + 85*4)...

Hi. Just to add... With 1165, your one solution is {3,4}

Be aware that with totals like 9520, etc, you would have 3 solutions:
{0, 112}, {17, 57}, {34, 2}

Solver would return only 1 solution.

Note that it grows quickly: A total of 28050 would have 7 solutions, etc...
{0, 330}, {17, 275}, {34, 220}, {51, 165},
{68, 110}, {85, 55}, {102, 0}

= = =
Dana DeLouis



Stan wrote:
Should i use solver for this scenairo or try other ways?

Here i have 2 products: A and B
price of A $275
price of B $85

If i only have the total sales amount of A+B eg ($1165= 275*3 + 85*4), how
can i work back the quantity for each of the category?

Thx guys~