# Re: Rounding up to a certain number

Solved
Jump to Solution
367 1
cancel
Showing results for
Search instead for
Did you mean:
4 - Data Explorer

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)?

1 Solution

Accepted Solutions
11 - Venus

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.

2 Replies 2
11 - Venus

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.

4 - Data Explorer

That works great, thanks so much!