help with formula
 

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.

help with formula
 

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.

help with formula
 

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

Jim Thomlinson


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

help with formula
 

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.

help with formula
 

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

Jim Thomlinson


"james" wrote:

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.

help with formula
 

getting the)
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?

"Jim Thomlinson" wrote:

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

Jim Thomlinson


"james" wrote:

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.