Formula
 

I need a formula to count. I am working on an inventory list. We sell by the
boxes but our supplier orders by number in each box. There is 100 in each
box. I need for a cell to count every 100 and reference it as being 1 box.

Formula
 

Perhaps an example of your data and results wanted;

Number of boxes:

=If (MOD(count of items,100)=0,INT(count of items)/100),INT(count of
items)/100)+1)



"Baderinwa3" wrote:

I need a formula to count. I am working on an inventory list. We sell by the
boxes but our supplier orders by number in each box. There is 100 in each
box. I need for a cell to count every 100 and reference it as being 1 box.

Formula
 

.... or =ROUNDUP(count of items/100,0) ?
--
David Biddulph

"Toppers" wrote in message
...
Perhaps an example of your data and results wanted;

Number of boxes:

=If (MOD(count of items,100)=0,INT(count of items)/100),INT(count of
items)/100)+1)

"Baderinwa3" wrote:

I need a formula to count. I am working on an inventory list. We sell by
the
boxes but our supplier orders by number in each box. There is 100 in
each
box. I need for a cell to count every 100 and reference it as being 1
box.

Formula
 

.....YEP!

"David Biddulph" wrote:

.... or =ROUNDUP(count of items/100,0) ?
--
David Biddulph

"Toppers" wrote in message
...
Perhaps an example of your data and results wanted;

Number of boxes:

=If (MOD(count of items,100)=0,INT(count of items)/100),INT(count of
items)/100)+1)

"Baderinwa3" wrote:

I need a formula to count. I am working on an inventory list. We sell by
the
boxes but our supplier orders by number in each box. There is 100 in
each
box. I need for a cell to count every 100 and reference it as being 1
box.