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



"Gary''s Student" wrote:

Hi James:

You just need some parens:

=((C15*D15)*2+(D15*E15)*2)/1728
--
Gary''s Student - gsnu200908


"james" wrote:

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.