Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating cost of product
-- Novice I have checked the Microsoft help site, but without the necessary knowledge, it is not possible to find the solution to my problem. I have three sets of variables (PATTERN - 8 options, AREA- 4 options, HEIGHT - 6 options,) in one column (three seperate cells). Each variable is presented in the form of a drop down menu (got that procedure from the website) in the appropriate cell. How do I create a formula, taking all the variables into consideration and then point to the correct prices per meter, depending on the result of the mixture of variables? If this is possible in Excel, I will be delighted. If more information is needed, my email address is Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating cost of product
Do you have a list of the possible combinations with prices? If so what form
does that take? "Grahams" wrote: -- Novice I have checked the Microsoft help site, but without the necessary knowledge, it is not possible to find the solution to my problem. I have three sets of variables (PATTERN - 8 options, AREA- 4 options, HEIGHT - 6 options,) in one column (three seperate cells). Each variable is presented in the form of a drop down menu (got that procedure from the website) in the appropriate cell. How do I create a formula, taking all the variables into consideration and then point to the correct prices per meter, depending on the result of the mixture of variables? If this is possible in Excel, I will be delighted. If more information is needed, my email address is Thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating cost of product
You need to create a table. See this screencap. It may give you an idea:
http://img508.imageshack.us/img508/5092/lookup1cw5.jpg -- Biff Microsoft Excel MVP "Grahams" wrote in message ... -- Novice I have checked the Microsoft help site, but without the necessary knowledge, it is not possible to find the solution to my problem. I have three sets of variables (PATTERN - 8 options, AREA- 4 options, HEIGHT - 6 options,) in one column (three seperate cells). Each variable is presented in the form of a drop down menu (got that procedure from the website) in the appropriate cell. How do I create a formula, taking all the variables into consideration and then point to the correct prices per meter, depending on the result of the mixture of variables? If this is possible in Excel, I will be delighted. If more information is needed, my email address is Thanks in advance. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating cost of product
Area 1 Pattern 1 Height 1 x 202 per meter Number The number of
meters is manually inserted in own cell Area 1 Pattern 1 Height 2 x 213 per meter Area 1 Pattern 1 Height 3 x 238 per meter Area 1 Pattern 1 Height 4 x 262 per meter Area 1 Pattern 1 Height 5 x 297 per meter Area 1 Pattern 2 Height 1 x 332 per meter Area 1 Pattern 2 Height 2 x 356 per meter Area 1 Pattern 2 Height 3 x 356 per meter Etc.€¦€¦. Area 2, Pattern 1 Height 1 x 219 per meter And so on €¦€¦. Area, Pattern and Height are selected by means of a drop down menus, each in their own cell in the same column Number of meters is entered manually. (Own cell same column as above) Last cell to consider all the variables, select correct price per meter and then multiply by number of meters, to provide cost (selling price of an order). -- Novice "daddylonglegs" wrote: Do you have a list of the possible combinations with prices? If so what form does that take? "Grahams" wrote: -- Novice I have checked the Microsoft help site, but without the necessary knowledge, it is not possible to find the solution to my problem. I have three sets of variables (PATTERN - 8 options, AREA- 4 options, HEIGHT - 6 options,) in one column (three seperate cells). Each variable is presented in the form of a drop down menu (got that procedure from the website) in the appropriate cell. How do I create a formula, taking all the variables into consideration and then point to the correct prices per meter, depending on the result of the mixture of variables? If this is possible in Excel, I will be delighted. If more information is needed, my email address is Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PRODUCT RESULTS/VALUE ARE NOT CALCULATING CORRECTLY | Excel Worksheet Functions | |||
Calculating cells cost hours | Excel Discussion (Misc queries) | |||
How do I calculate cost of raw materials to final product? | Excel Discussion (Misc queries) | |||
ENTER PRODUCT # AND HAVE assign DESC. & COST in invoice | New Users to Excel | |||
Confusion on adding percentage of cost to that cost. | Excel Worksheet Functions |