need 4 sashes

length of material is 300 cm

width of material is 150 cm

width of sash is 50 cm

3 sashes per length of material

I need to have 600 cm of material

2 sashes left over

✔ Best Answer

You might want to consider using this formula, which answers your original question:

"therefore I need a formula to give me the required 6 metres"=ROUNDUP(A1/3,0)*3

Enter the number of sashes required in A1.

Some examples of the results

Sashes Metres 1 3 1/3 = .333, ROUNDUP(.333,0) = 1, 1x3 = 3 2 3 2/3 = .666, ROUNDUP(.666,0) = 1, 1x3 = 3 3 3 4 6 4/3 = 1.333, ROUNDUP(1.333,0) = 2, 2x3 = 6 5 6 6 6 7 9 8 9 9 9

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Sounds like homework... Aside from that, I don't know what you are asking for. It seems like you have it all figured out.

Three 300 x 50 sashes from one piece.

One 300 x 50 sash from a second piece.

One 300 x 100 "scrap" left over.Make 2 more sashes. Keep them as spares or give them to a charity.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Hi DerbyDad03 - yes that is correct, however when I use goal seek to find the length (in metres) of fabric required for 4 sashes it give me 4 metres instead of the required 6 metres, therefore I need a formula to give me the required 6 metres; ie 6 metres, cut into 2 lengths of 3 metres to produce the 4 sashes (2 left over for another day) - hope this makes sense, thanks.

Since this sounds very much like a homework problem, which we do not like to answer directly in this forum, I'll offer a suggestion and let you see if you can figure out the final answer. That is the standard approach for homework problems. We'll point you in the right direction and hope that you can follow the path to knowledge.

Please let us know if you figure it out, or if you need more help.

Take a look at the ROUNDUP function. By using the correct value for the

num_digitsargument, you should be able to use the number of sashes that you can get from 1 piece, along with the number of sashes you want, to determine how many 300 cm lengths of fabric you need.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Hi DerbyDad03 I don't know where "homework" came from but it takes me back, almost 50 years!

Just to let you know that I have solved this a different way, by producing a table that has column headings from 3 to 96 lengths and beneath those the number of sashes available to that length, ie a 3 metre length produces 1, 2 and 3 sashes and a 9 metre length produces up to 9 sashes, then I just lookup the required amount and the column heading will tell me the length of material needed :) Long winded I know, but it gives me the answers.

Thanks & Regards, appreciate you taking the time...

You might want to consider using this formula, which answers your original question:

"therefore I need a formula to give me the required 6 metres"=ROUNDUP(A1/3,0)*3

Enter the number of sashes required in A1.

Some examples of the results

Sashes Metres 1 3 1/3 = .333, ROUNDUP(.333,0) = 1, 1x3 = 3 2 3 2/3 = .666, ROUNDUP(.666,0) = 1, 1x3 = 3 3 3 4 6 4/3 = 1.333, ROUNDUP(1.333,0) = 2, 2x3 = 6 5 6 6 6 7 9 8 9 9 9

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Excellent DerbyDad03 I have used your formula to incorporate a change in the length of sash, the width of material and width of sash as shown below...

G H I

7 Length Sash 300 cm

8 Width Material 150 cm

9 Width Sash 50 cm

10 Number per Sash 3

12 Sashes Required 6

14 Length Material 6 m

=ROUNDUP(H12/(H8/H9),0)*H7/100

Hope it makes sense, and I appreciate you input, perfect!Regards

I'm glad I was able to help. In the future, should you need to post example data, please click on the following line and read the instructions found via that link. Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History