- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 20, 2023 06:12 AM
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)?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 20, 2023 05:07 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 20, 2023 05:07 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 21, 2023 05:43 AM
That works great, thanks so much!
