View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andy62 andy62 is offline
external usenet poster
 
Posts: 158
Default number of items fit into item

Can you provide an example of what you mean? Include some data, and point
out what is making it so tricky.

"Dreamstar_1961" wrote:

tryed that but dos't seem to be working, what this is for is a fit size, that
is we have a number of location of a given size, I need a formula that when
we put the size of the part in it will show how many will fit in a given
location

"andy62" wrote:

Seems like you would just multiply to compute the respective volumes, and
then divide. So what's the catch?

"Dreamstar_1961" wrote:

can any one think of a formula to find out how many items will fit in to a
given Dimension, that is I have a item that is so many width*height*depth
into a location of width*height*depth
ex 10*10*10 into a item of 10*10*10 = 1