help with formula

  • Thread starter Thread starter james
  • Start date Start date
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.
 
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 ...
 
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.
 
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?
 
Back
Top