Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Rounding up to a certain number

Topic Labels: Formulas
Solved
Jump to Solution
1241 2
cancel
Showing results for 
Search instead for 
Did you mean: 
UrbnJ
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Sho
11 - Venus
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.

See Solution in Thread

2 Replies 2
Sho
11 - Venus
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.

UrbnJ
5 - Automation Enthusiast
5 - Automation Enthusiast

That works great, thanks so much!