Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|