Formula

[Guest]

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.

 

[Guest]

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)

 

[David Biddulph]

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

 

[Guest]

.....YEP!

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