Formula for adding up 10' lengths of pipe needed

[bembry369]

I'm fairly new to Excel so bare with me. I'm trying to figure out a formula that will add how many 10' lengths of any given material needed. For example if If I need Qty. 30 32" pieces cut out of a 10' length, how may 10' lengths do I need?

 

[Eric W]

Welcome to the board.

Try:

	A	B	C	D
qty	len in inches	# of 10' lengths
30	32	10	8

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

</tbody>

Sheet18​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C2[/TH]
[TD="align: left"]=ROUNDUP(A2/INT(120/B2),0)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D2[/TH]
[TD="align: left"]=ROUNDUP(A2*B2/120,0)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



The formula in C2 is what you'd want if you can't connect left-over pieces from multiple 10' lengths together to make another 32" length. If you have a way to connect them (welding?, sewing?), you can use the formula in D2.

 

[bembry369]

Thanks Eric, this works perfectly!

 

[bembry369]

Thanks Eric, C2 is what I was looking for, works perfectly

 

[Eric W]

Glad to help!