help with formula

[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.

 

[Gary''s Student]

Hi James:

You just need some parens:

=((C15*D15)*2+(D15*E15)*2)/1728

 

[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 ...

 

[james]

great thanks!
and for duplicating all formulas in a row to row beneath?

 

[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.

 

[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?