| Home |
| Search |
| Today's Posts |
|
#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. |
Threaded Mode
