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
Software