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
1	qty	len in inches	# of 10' lengths
2	30	32	10	8

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet18​

Worksheet Formulas Cell Formula C2 =ROUNDUP(A2/INT(120/B2),0) D2 =ROUNDUP(A2*B2/120,0) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

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!