Not as simple as it sounds. Set up a table of lengths, inventory, formula,
and desire such as
Formula for col c copied down =MIN(B5,INT((D4/A5)))

formula for col d copied down
=D4-(A5*C5)

I can send you a workbook, if desired. Ask OFF list ONLY!!!!
Length Inv Use 5,000.00 5,000.00
2,000.00 10 2 1,000.00
4,000.00
1,800.00 10 -
-
1,600.00 0 -
-
1,400.00 10 -
-
1,200.00 0 -
-
1,000.00 0 -
-
800.00 0 -
-
600.00 10 1 400.00
600.00
400.00 2 1 -
400.00
200.00
- - -
100.00
- - -
1.00
- - -





--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"davers" wrote in message
...
I dont know if this is the right place to ask this question but i am
looking
for a simple excel formula to create a cutting list.

ie

1200
1400
1800
2000
600

The above lengths needs to be cut from 4000
so 1200 + 1800 = 4000 and 1200+2000+600 =3200
so i require 2 lengths at 4000, surely its a simple excel formula, any
help
would be much appreciated.