A
art
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.
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.