do I need to use a roundup func.??

M

matmich

i have a formula which give me an order qty #:
how would I get this number rounded up to the next number divisible b
16

Ex: my formula returns 110 -- but I want 112

my formula returns the # of units for an item, however for this ite
there are 16units=1 case, and this is how the product is ordered by th
cas
 
R

RagDyeR

Try this:

=CEILING(A1,16)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


i have a formula which give me an order qty #:
how would I get this number rounded up to the next number divisible by
16

Ex: my formula returns 110 -- but I want 112

my formula returns the # of units for an item, however for this item
there are 16units=1 case, and this is how the product is ordered by the
case
 
J

Jonathan Cooper

If you didn't have to roundUP, the easiest way is (assuming A1=110

=mround(A1,16

To roundup,
=IF(MROUND(A1,16)-A1<0,MROUND(A1+8,16),MROUND(A1,16)

----- matmich > wrote: ----

i have a formula which give me an order qty #
how would I get this number rounded up to the next number divisible b
1

Ex: my formula returns 110 -- but I want 11

my formula returns the # of units for an item, however for this ite
there are 16units=1 case, and this is how the product is ordered by th
cas
 
Top