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