I am writing a workbook that can calculate the weights of steel. There
are space issues with the workbook. It will be used in our shop and it
needs to stay simple.

I got some good advise from some folks on here. They told me it was a
bad idea to use merged cells.

I am trying to write a formula for a trapezoid. I am really bad at
using the left and right cell functions. I really want to use these.
The way I got the trapezoid formula was to add columns and cells. If I
can use a formula that uses the right and left formulas I would prefer
this. Here is the formula that I was able to come up with.
=IF(LEFT(G22,3)="TPL",((O22*12+Q22 +
S22*12+U22)/2*(W22*12+Y22))*VLOOKUP(G22,Sheet2!A:B,2,FALSE)/144*D22,((W22*12)+Y22)*(VLOOKUP(G22,Sheet2!A:B,2,F ALSE)/12)*D22)

I have posted the information on my web page for people to look at to
verify what I am talking about. Let me know if you have any questions
or comments. WWW.MYKALTX.COM


--
mykaltx
------------------------------------------------------------------------
mykaltx's Profile: http://www.excelforum.com/member.php...o&userid=22055
View this thread: http://www.excelforum.com/showthread...hreadid=396151