Rounding question

H

Helen

Hello,

I have created a report that calculates how many shipping pallets is needed
for a particular shipment. I need the result to always round up.
Currently, if the result is 1.1 it rounds to 1... But I need it to always
round up, in this case to 2.

Any suggestions on how to do this?

Many thanks!

Helen
 
A

Allen Browne

The Int() function rounds down, so you can round up by negating the result,
using Int() and then negating again.

Try:
= - Int( - [your calculation here])
 
Top