Formula "Let me know if this does 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 like 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 in Q14 and inches in S14 the formula will pull the data off of the database for G14. All cells will work together to calculate the weight 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 is .2836 per sq inch. The formula to get volume is WxHxL. As I have 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 listed next to the height 15 which will be the width. The length will be listed in the ft and inches field.

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

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

[mykaltx]

Let me know what type of information you need.

[mykaltx]

Does anyone have a clue?

[swatsp0p]

Sorry, but I can't (won't) open files. If you could post a screen shot, it may be beneficial.

However, I don't understand your dilema. WxHxL should return the correct results regardless of whether the plate is square or rectangular. What are we missing?

[mykaltx]

Tell me how and I will. I know how to get screen shot. I just do not know how to post one.

[swatsp0p]

you need to save the .jpg version of your screen shot (.bmps are too big), as you reply to this post, scroll down to the "Additional Options" section and click on the "Manage Attachments" button...follow the direction from there...

HTH

Bruce

note: this tip is for posters using ExcelForum.com

[Dave Peterson]

And just to add...

Lots of people connect directly to the MS Newsservers and won't see that
attachment.

Posting in plain text may get more people to respond.

swatsp0p wrote:
>
> you need to save the .jpg version of your screen shot (.bmps are too
> big), as you reply to this post, scroll down to the "Additional
> Options" section and click on the "Manage Attachments" button...follow
> the direction from there...
>
> HTH
>
> Bruce
>
> note: this tip is for posters using ExcelForum.com
>
> --
> swatsp0p
>
> ------------------------------------------------------------------------
> swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
> View this thread: http://www.excelforum.com/showthread...hreadid=393339

--

Dave Peterson

[mykaltx]

I have been trying to save it as a jpeg and the system says it is too large.

[mykaltx]

I have too much information on my jpeg. Not sure how to downsize. It is just a screen shot.

[swatsp0p]

As Dave says, you are better off to copy/paste some of your formulas in your post so all can see. You will get much more help that way.

Bruce