View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Stan is offline
external usenet poster
 
Posts: 150
Default Solver or Other?

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~