help with formula

J

james

ok, im trying to do this;
=(C15*D15)*2+(D15*E15)*2/1728

thats the total divided by 1728

c15 is 22, d15 is 4, e15 is 16

its to determine cubic feet of wood in a drawer, so c15 is width, d15 is
height, e15 is depth, multiplied by 2 for 2 sides and front and back, then
total divided by 1728 to determine cubic feet.
result should be 0.1759
HELP!!!
James

also tryind to duplicate all formulas in a row in row beneath.
 
J

Jim Thomlinson

or with a little algebra
=(C15+E15)*2*D15/1728

Add the length of the sides and the back. Double it and Multiply that by the
height. Divide by 1728 to cube it and ...
 
J

Jim Thomlinson

Highlight the cells you want to repeat. Copy and paste or drag with the cross
hair in the bottom right corner of the right most cell.
 
J

james

getting there:)
what about stopping a cell saying; #VALUE!
i have about 100 clees doing this when unused rows are left blank, any way
of doing this in bulk?
 

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

Top