| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
