Round to nearest multiple

[ayadav8]

Hey,

I need to update "Recommended Order" which is a round up number of "order" quantity to the nearest multiple of "carton qty". Attached is an example of the scenario.  and "Recommended order" need to be always higher than "Order" quantity.

Thank you!

[jrgo]

= ROUND(([Order]/[Carton qty]) + 0.4) * [Carton qty]

Should do the trick!

***minor edit in case the division is a whole number***

[jrgo · Accepted solution]

Ceiling function would actually be more appropriate as I think of it.

CEIL([Order]/[Carton qty]) * [Carton qty]

[ayadav8]

Thanks @jrgo. the logic works.