i'm having a problem finding a formula that will work for my situation. i work in construction, and we have these ordering forms we fill out for our big jobs.
everything has an item name, item number and measurement. there are 12 item names, each with around 10 item numbers and 8 item measurements. i want to be able to fill in a name, number and measurment in each cell and have it sum to a set price.
for example:
S125 + 162 + 25GA = $100
S125 + 250 + 25GA = $200
S162 + 800 + 18GA = $600
is there any way to do this?? i don't mind at all entering in all of the different combinations and prices on a seperate spreadsheet for it to link to... i just want my guys to be able to enter the measurements into the form and have the price fill in without them having to look it up.
helppp!!!
2007-12-06
09:17:57
·
3 answers
·
asked by
underpre$$ure
2
in
Computers & Internet
➔ Software
to answer, "what determines the price?":
the price is already set. it is set up so that you find your item number in the first column, then find your measurment in the top row, and that will lead you to your price in the columns/rows following... confused yet? haha, i'm not quite sure how to explain... like, the first column would have all of the item numbers, for example:
162
250
350
362
then the top row has all of the item measurements, for example:
25GA 22GA 20GA 18GA
then you follow to find your price, for example:
25GA 22GA 20GA 18GA
162 $100 $110 $120 $115
250 $200 $220 $225 $205
350 $110 $115 $130 $180
...those aren't the actually prices, but that's how it works.
2007-12-06
10:47:36 ·
update #1