View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ezexperiment ezexperiment is offline
external usenet poster
 
Posts: 1
Default how do I 'nest' multiple quantities from standard stock lengths

I have random quantity lengths which I need to cut from standard stock
lengths. Is there a formula to calculate this 'Nesting' Facility.

a b c
d
eg. random quantity lengths = , , ,

Available stock Lengths = 9.0, 10.5, 12.0, 13.5, 15.0

Nesting Answer = a+d b+c
1@ 10.5 + 1@ 12.0