Skip to main content
Solved

Rounding up to a certain number

  • November 20, 2023
  • 2 replies
  • 64 views
U
Forum|alt.badge.img+4

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

Best answer by Sho

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

S
Forum|alt.badge.img+21
  • Sho
  • Inspiring
  • Answer
  • November 21, 2023

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.

U
Forum|alt.badge.img+4
  • UrbnJ
  • Author
  • New Participant
  • November 21, 2023

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!

Terms & ConditionsAccessibility statement