View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

=ROUNDUP(A21/50,0)*50

or

=CEILING(A21,50)

--
HTH

Bob Phillips

"karenm" wrote in message
...
I am trying to calculate the number of raw material bags I need in a

batch.
If I use the mround function is will round down. Is there a way to only
round up?