Help

Rounding up to a certain number

Topic Labels: Formulas
Solved
Jump to Solution
401 2
cancel
Showing results for 
Search instead for 
Did you mean: 
UrbnJ
4 - Data Explorer
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
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.

That works great, thanks so much!