Rounding up to a certain number

[UrbnJ]

Hello all,

I have a problem that I'm trying to fix, and I have not been able to fix it with the posts with related questions.

I have a field with numbers that I want to round up to another field with numbers.

I'll explain the situation:
So it's about ordering products. I get an order recommendation let's say for product A this is 55. But the products are packed in boxes of a certain quantity (let's say 20), so I cannot order 55 pieces, I'd have to order either 40 pieces or 60 pieces (2 or 3 boxes of 20 pieces).

Is it possible to use a formula to automatically round the number upward to meet the required amount (in the examples this should be 60)?

[Sho · Accepted solution]

Hi @UrbnJ ,

For example, this formula

Required Qty. :

IF(AND({Package Qty.},{Order Qty.}),
  ROUNDUP({Order Qty.}/{Package Qty.}, 0)*{Package Qty.}
)

Calculate the required quantity in packages that is greater than the number of orders.

[UrbnJ]

That works great, thanks so much!