Help me

M

mykaltx

I have added information on my web page www.mykaltx.com to help.
I got some great input from some of the other users.
I appreciate all the help.

The spreadsheet is now able to calculate the weight of steel beams
pipe, angle channel and plate.
What I need now is for it to calculate the weight of a trapezoid. Th
spreadsheet will have to use the weight for plate. The kicker is i
will have to calculate the weight for plate the top width the botto
width and the length as well.
If you have any ideas let me know.

Also I am not that great at explaining myself. Let me know if I need t
clarify.

I have added my formula for trapezoid weights. I have also added a pag
that show a new formula.

Here is the formula I am having problems with.
=IF(ISERROR(VLOOKUP(G21,Sheet2!A:B,2,FALSE)),""
IF(LEFT(G21,2)="PL",((O21*12+Q21)*(W21*12+Y21))*VLOOKUP(G21,Sheet2!A:B,2,FALSE)/144*D21,((W21*12)+Y21)*(VLOOKUP(G21,Sheet2!A:B,2,FALSE)/12)*D21)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

This formula needs help 2
Vlookup for 3 sheets 6
Help with formula 5
Formula Help "Let me know if I do not make sence". 3
Need HELP with Formula 3
Vlookup, replace true text result with "X" 5
IF / Vlookup formula 3
Need Formula to Calculate Time/Overtime (2) 2

Top