View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Sum of combinations

Hi,

I need help to approach a problem of this kind:
I have 4 products: A, B, C, D. I have to fix their prices.
Possible prices of product A: pa1, pa2, pa3, pa4.
Possible prices of product B: pb1, pb2, pb3.
Possible price of product C: pc1.
Possible prices of product D: pd1, pd2.

I want to get all possible revenues of sales of the products.

example
combin 1: pa1+pb1+pc1+pd1
combin 2: pa2+pb1+pc1+pd1
combin 3: pa3+pb1+pc1+pd1
combin 4: pa4+pb1+pc1+pd1
.....


thanks
p.