Formula Help "Let me know if I do not make sence".

[mykaltx]

I have listed everything on my web page www.mykaltx.com

I have posted my information on my web site for anyone who would lik
to help me. I hope this will clarify what I am looking for.

The sheet labeled “sheet 2” is my database.
If I type the number of peaces I want in the column D14 and the ft i
Q14 and inches in S14 the formula will pull the data off of th
database for G14. All cells will work together to calculate the weigh
for the various steel items. This is great for our company.

Now I would like to modify this.

I will also need it to work for steel plate. The weight of steel i
.2836 per sq inch. The formula to get volume is WxHxL. As I hav
listed in the spreadsheet the height will go with the plate “PL 3/16
this will be the height. The width will be the second dimension liste
next to the height 15 which will be the width. The length will b
listed in the ft and inches field.

As you can see in my database called sheet two. The formula pulls of
of the database to calculate the weight. The problem is it calculates
square for plate. Sometimes the plate will be rectangular.

I have listed a second spreadsheet that is highlighted with baby blu
at the time and is labeled estimate. This has a formula similar to wha
I am looking for. I do not like it though. It will not pull off of m
database

 

[mykaltx]

I am not very good at explaining myself. If you need any othe
information let me know

 

[mykaltx]

Does anyone have clue

 

[Dave Peterson]

Lots of people won't take the time to go to your site to find what you're
asking.

You may want to post back in plain text. You may get more responses.