Let me know if this works:

=INT(A2/A3)*INT(B2/B3)*INT(C2/C3)

Where the numerators are the width/height/depth of the available space
("Dimension" from your first note) and the denominators are for the given
part/item.

"Dreamstar_1961" wrote:

what I'm trying to get is if item is say 28*13*14 and the value of the item
it's to go into is 29*14*15 then what will fit is 1, but if the item is 1*1*1
then the answer is 1000's what I'm after is the formula to work out the
number, this is being used for a fit size test.

"andy62" wrote:

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