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~