Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Many possible variations
Hello all:
I would like to know how to make this calculation. Below is a list of products and types and prices. I would like to know how can I make that excel should tell me all the variations and combinations that's possible. Product Type 1 Type 2 Type 3 Type 4 Type 5 Wood 1.29 1.39 1.49 1.59 1.69 Plastic 0.55 0.89 0.99 1.2 1.27 Metal 0.44 0.87 0.98 1.04 1.12 For example I want that in a certain cell it should start to tell me all the variable prices possible if someone orders all three products. It should give the results based whether the order is for type 1 for all of them, type 2 for all of them and so on. It should then give the results for type 1 for wood but type 2 for plastic and so on. I know there are a lot of possibilities. Is there a way that I can see all possible variations and excel should give the each result in a different cell? Please help. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graphs with multiple variations | Excel Discussion (Misc queries) | |||
Variations on Sumif | Excel Worksheet Functions | |||
Variations in a sheet's Visible status | Excel Discussion (Misc queries) | |||
All variations of a set of numbers and letters | Excel Discussion (Misc queries) | |||
number variations | Excel Discussion (Misc queries) |