Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sales Cost Calculator - lots of variables!! Help Please!
Dear All,
I am trying to make a basic sales cost calulator for my sales team. It consists of lots of variables, of which I have managed to solve a few. The main problem I have is the following: I have 4 types of variables (more if I can use them, but 4 minimum) which affect the price 1) Destination (6 options e.g New York) 2) Mode of transport (3 options e.g.Sea Freight ) 3) Freight rate (4 options e.g $45 per cuft) 4) Destination rate (4 options e.g. full unpacking, not just curbside deliery ) I have the above as options using Data - Validation drop down screens. What I want to do is to get, for an example the cost for a job with X [units of measurement] and the following responses: 1 - 4 2 - 2 3 - 1 4 - 4 All of the rates are on a seperate worksheet on the workbook, so I'll need to be able to have a solution that is able to use a different worksheet (unless I transfer everything on to the main one which is a possibility, but not clean. Can anybody exaplain, as basically as possible how I can do this please? Any responses gratefully received. Jamie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BIG FILE LOTS of Variables that need to be counted | Excel Discussion (Misc queries) | |||
Creating a Utility Cost calculator | Excel Discussion (Misc queries) | |||
Current Cost versus Original Cost | New Users to Excel | |||
Confusion on adding percentage of cost to that cost. | Excel Worksheet Functions |