Help with formula

[mykaltx]

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

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

I am trying to write a formula for a trapezoid. I am really bad a
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
can use a formula that uses the right and left formulas I would prefe
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,FALSE)/12)*D22)

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

 

[swatsp0p]

It seems you have achieved your goal. Your sample looks functional t
me. Is there a question here?

The comments regarding merged cells relate more to functionality whe
it comes to copying, sorting and other tasks that are greatly hampere
or prohibited by merged cells. I would think you could accomplish wha
you are doing without merging cells, but at this point I don't see i
interfering with what you have.

Good Luck

Bruc

 

[mykaltx]

Hey Mr. Bruce,

On the second sheet I am able to calculate a trapezoid by adding cells.

I guess what I am asking is how do I write a formula for calculating a
trap. Without adding the cells. I am not able to do it with the right
and left functions. I am not sure how to code it.
Say for example I want the dimension in cell C15 "x 15" I do not know
how to pick it up for calculation in the trapezoid.

I hope that makes sense.

 

[swatsp0p]

This formula will return the "15" from your <Book3>Sheet1!C18:

=RIGHT(C18,LEN(C18)-(FIND("x",C18)+1))

notice the use of FIND. What I did was find the 'x' in you
measurement and added one to count the space after the 'x', and retur
whatever is to the right of that. If the same is applied to C15
"13.75" is returned.

HTH

Bruc

 

[mykaltx]

Cool
I am really interested in learning more about coding in excel. I jus
do not know where to go to take a class for formulas. There are plent
of classes for VB

 

[swatsp0p]

A real good place to start is the built in Function Help system. Fo
example: Click on Insert>Function. In the box that opens, select Tex
from the "Or select a category:" drop down. Scroll in "Select
function:" to FIND, highlight it and then click on th
_Help_on_this_function_ link.

You will 'find' (no pun intended) a lot of help on what it does and ho
it works.

Study that, pick another function and repeat.

Good Luck!

Bruc