Formula to get full lengths from rolls

[LazyLarry]

I need a formula to work out number of rolls for X amount of lengths an I can' have part of a length from different roll

For example if I have a roll size of 20 metes and lengths of 3 metres, for 12 lengths it is easy 12 x 3m = 36m divided by 20m rl = 2 Rolls

The issue becomes when it goes up to 13lengths the answer needs to b be 3 rolls to get full lengths because 13 x 3m = 39 / 20 = 2 but one length would be made up of 2 metres from 1 roll and 1 metre from the second.

How do I write the formula to get past this problem?

Thanks in advance.

 

[jtakw]

Hi,

Try this:

Book1
	A	B	C	D
1	Roll Size	Length	# Lengths	Rolls needed
2	20	3	12	2
3	20	3	13	3
4	20	3	14	3
5	20	3	15	3
6	20	3	16	3
7	20	3	17	3
8	20	3	18	3
9	20	3	19	4
10	20	3	25	5
11	20	4	25	5
Sheet463

Cell Formulas
Range	Formula
D2	=ROUNDUP(C2/ROUNDDOWN(A2/B2,0),0)

 

[LazyLarry]

So simple. Thank a lot.

 

[jtakw]

You're welcome.