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.
|